Import Data From Oracle To SQL Server

Question

User-530929707 posted

Hello to Everyone,

I want to Import Data From Oracle To SQL Server, please suggest me suitable suggestion.

i write in C# but it's taking too much time to execute.

What should i do?

REPLY ASAP?

Answer 1

User-693248168 posted

Did you try the Import wizard in SQL server.

Right click any database in Ms Sql server --> tasks --> import data

Answer 2

User-530929707 posted

but i have records that are already imported in SQL Server & used in System.

Import Data will affect that records.

Answer 3

User-530929707 posted

and it will also give error

ORA-12560: TNS:protocol adapter error (Microsoft OLE DB Provider for Oracle)

Answer 4

User-29804325 posted

Hi,

Try to use Oracle DTS tool to transfer data from oracle to sql server.

http://it.toolbox.com/blogs/david/dts-in-oracle-14100

Also you can follow these links and tutorials, it maybe can guide you.

http://www.swissql.com/products/oracle-to-sqlserver/oracle-to-sql-server.html

http://www.sql-server-performance.com/2003/migrating-from-oracle-to-sql-server/

http://www.devshed.com/c/a/Oracle/StepByStep-Guide-to-Importing-Data-from-Oracle-XE-to-SQL-2005/

Hope this can help you.