重复地将数据从SQL Server移动到Oracle [英] Moving Data from SQL Server to Oracle Repeatedly

问题描述

定期将表数据从SQL Server移动到Oracle（在* nix上）的最合理的方法是什么？

What are the most reasonable ways to move table data from SQL Server to Oracle (on *nix) on a regular basis?

推荐答案

使用SQL Server集成服务（SSIS）可能是您最好的选择。如果你不熟悉SSIS，尝试一些东西的最好的方法是使用SQL Server导出向导，并为它创建一个SSIS包。例如，如果进入SQL Server Management Studio并右键单击数据库，然后选择任务 - >导出数据。从那里点击下一步，直到您进入选择目的地步骤。选择适用于Oracle的Microsoft OLE DB提供程序，然后单击属性以定义数据库连接。当单击向导时，在保存并执行页面上，请确保选中标有保存SSIS包的复选框，在下一个屏幕上指定保存SSIS包的位置。一旦完成导出向导，您的数据将被导出，您将有一个SSIS包，您可以使用它，或进入和调整它做更多的具体事情。
一旦你有你的SSIS包，你可以通过创建一个SQL Server代理作业来安排它。

Using SQL Server Integration Services (SSIS) is likely your best bet. If you're not familiar with SSIS, the best way to try something out is to use the SQL Server Export Wizard and have it create an SSIS package for you. For example, if you go into SQL Server Management Studio and right-click on your database, then select Tasks->Export Data. From there click next until you get to the "Choose a Destination" step. Select the "Microsoft OLE DB Provider for Oracle" and click Properties to define your database connection. When you click through the wizard, on the Save and Execute page, make sure you check the checkbox labelled "Save SSIS Package", on the next screen specify where to save the SSIS package. Once you finish the Export Wizard, your data will have been exported and you will have an SSIS package that you can use as is, or go in and tweak it to do more specific things. Once you have your SSIS package, you can schedule it by creating a SQL Server Agent Job.

这篇关于重复地将数据从SQL Server移动到Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！