Home » SQL & PL/SQL » SQL & PL/SQL » Records from sql server to Oracle
Records from sql server to Oracle [message #246846] Fri, 22 June 2007 04:01 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear Friends,

How can i move Records a table from one database(sql server)

to Oracle(9i) Database.Any Idea...

Expecting Your Replies.

Thanks,

Arun.
Re: Records from sql server to Oracle [message #246888 is a reply to message #246846] Fri, 22 June 2007 06:46 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
You can use BCP of SQL server to download your data to flat file and use Oracle SQL*Loader to upload it to Oracle table.

HTH.
Michael
Re: Records from sql server to Oracle [message #246916 is a reply to message #246888] Fri, 22 June 2007 08:02 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Oracle Migration Workbench?

MHE
Previous Topic: complex sql query
Next Topic: display in next line
Goto Forum:
  


Current Time: Fri Dec 09 05:43:31 CST 2016

Total time taken to generate the page: 0.17282 seconds