Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle DB Link to SQL Server 2000

 
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?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic