Home » RDBMS Server » Server Utilities » Export from SQL Server 2005 and Import to Oracle 10g (SQL Server 2005, Windows 2003, Oracle10g, Linux SUSE 10)
Export from SQL Server 2005 and Import to Oracle 10g [message #317151] Tue, 29 April 2008 12:49 Go to next message
dba_zia
Messages: 1
Registered: April 2008
Junior Member
Can anyone help me to show how to export a SQL Server 2005 database table data and import that data into a Oracle 10g database table?

I have tried to use the 'bcp' utility to export file from SQL Server but failed due to authentication error. I don't know how to authenticate from command line though I have passed all the credentials. For example,

bcp TEST.db.EMP out emp_table_out.txt -c -S Box -U Administrator -P admin

Can I use Oracle Data Pump utility to import the emp_table_out.txt file to load data in Employee table in Oracle from command prompt?

Thanks,
Zia
Re: Export from SQL Server 2005 and Import to Oracle 10g [message #317153 is a reply to message #317151] Tue, 29 April 2008 13:02 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have output your data in CSV format and then use SQL*Loader to load it in Oracle.

Regards
Michel
Previous Topic: Stuck on SQL*LOADER problem
Next Topic: oracle 9.2.0.6.0 / sunsolaris 9
Goto Forum:
  


Current Time: Tue Dec 06 00:12:23 CST 2016

Total time taken to generate the page: 0.05068 seconds