This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle DB Link to SQL Server 2000  RSS feed

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

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!