OraFAQ Forum: Server Utilities » Export from SQL Server 2005 and Import to Oracle 10g

Home » RDBMS Server » Server Utilities » Export from SQL Server 2005 and Import to Oracle 10g (SQL Server 2005, Windows 2003, Oracle10g, Linux SUSE 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export from SQL Server 2005 and Import to Oracle 10g [message #317151]

Tue, 29 April 2008 12:49

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

Report message to a moderator