Sadaf Mansuri’s Blog

August 17, 2010

Migrate your sql server 2000 database to oracle

Filed under: Uncategorized — admin @ 11:38 am
Few days back I was in need to convert sql server database 2000 to oracle.  Sql database was having plenty of tables and stored procedures. Oracle migration workbench did it properly. I came across some of the issues while working on it. Here is steps to do it.
steps
Install oracle sql developer migration workbench
Install sp3 for sql server and update for jdbc
Microsoft SQL Server 2000 Service Pack 3a
SQL Server 2000 Driver for JDBC Service Pack 3
Follow the steps from documentation from oracle

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress