Have Geek Brain

Copying oracle to sqlserver 2005 jdbc

Is there a way to copy a database from oracle to sqlserver 2005? Thanks to

0


a source to share


1 answer


You can migrate from Oracle to SQL Server using Microsoft SQL Server Migration Assistant . It is available for both SQL Server 2005 and 2008.



If you have a lot of (complex) stored procedures, etc., the migration can get a little tedious. I am experienced with databases with simple procedures and can just rewrite them and make a copy of the data for empty tables in SQL Server using import functions using the Oracle connector (can be used with SQL Server if you have installed Oracle client tools on the SQL Server machine ), So I didn't even need to use the Migration Assistant tool.

0


a source






More articles:


All Articles