File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle DB Link to SQL Server 2000

 
Amrit Kashyap
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Linking doesn't migrate data does it?
 
Amrit Kashyap
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic