两个不同数据库之间的数据传输 [英] Data transfer between two different databases

问题描述

我想将数据从Oracle传输到SQL Server，但该表包含大量行(4000万行).请建议我如何使用C#

解决方案来实现此目的div>

借助 BULKINSERT [ SQLSERVER中的导入/导出向导 [在oracle和sql-server-findings-and-observations之间移动大量数据 [ http://technet.microsoft.com/library/Cc917627 [ http://msdn.microsoft.com/en-us/library/ms188427.aspx [ ^ ]
StepByStep-Guide-to -从Oracle XE导入数据到SQL-2005 [ 解决方案

With the help of BULKINSERT[^] or import wizard you can copy the data.

And also using import/export wizard in SQLSERVER [^] you can copy or move data from/to any database using odbc drivers.

These are some links helps you to transfer data from oracle to sql.
moving-large-amounts-of-data-between-oracle-and-sql-server-findings-and-observations[^]
http://technet.microsoft.com/library/Cc917627[^]
http://msdn.microsoft.com/en-us/library/ms188427.aspx[^]
StepByStep-Guide-to-Importing-Data-from-Oracle-XE-to-SQL-2005[^]

这篇关于两个不同数据库之间的数据传输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！