Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Transfer db from sql server

Author  Topic 

kidaduo
Starting Member

45 Posts

Posted - 2007-12-13 : 11:01:36
What will be the best way to transfer database from sql to oracle server. I have almost 50 databases in sql, I dont want to create a dts for each and every database to transfer-- Is there a process to transfer entire database at one time

Josephine

Josephine

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-14 : 03:33:27
I think bcp or dts/ssis is your only way as the structure of the tables in oracle may be different.
Go to Top of Page
   

- Advertisement -