| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
