wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes Oracle DB Link to SQL Server 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle DB Link to SQL Server 2000" Watch "Oracle DB Link to SQL Server 2000" New topic
Author

Oracle DB Link to SQL Server 2000

Amrit Kashyap
Ranch Hand

Joined: Apr 23, 2006
Posts: 44
Hi,
I need to migrate data from MS SQL Server 2000 to Oracle database 10g. I am thinking of using db link for the same. Any particular do's and don't for using db link to connect to SQL Server???
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Linking doesn't migrate data does it?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Amrit Kashyap
Ranch Hand

Joined: Apr 23, 2006
Posts: 44
thanks Paul for your response.

I was planning to use Oracle DBLink to connect to SQL Server.

Now my oracle database is on Unix platform and SQL Server is on windows platform.

As of now, I was thinking of writing sql Inserts over DB Link to fetch data from Sql Sever to Oracle Database.

I asked if the use of Oracle DBLink will be a good choice and what do's and don'ts need to be taken care. Is there any other alternative method of data migration is available?

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle DB Link to SQL Server 2000