Edwin Betancourth
asked on
Best utility to convert sql scripts from MS SQL to Oracle and viceversa
What is the best utility to convert sql scripts created in MS SQL 2000 / MS SQL 2005 to oracle 9i / 10g?
Free tools (Microsoft & Oracle) :
/* Microsoft SQL Server Migration Assistant (SSMA) for Oracle */
https://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
/* Oracle SQL Developer Migration Workbench */
http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html
/* Microsoft SQL Server Migration Assistant (SSMA) for Oracle */
https://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
/* Oracle SQL Developer Migration Workbench */
http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html
ASKER
This utilities are for migrating DBs, Tables etc. I strictly looking for an script converter from Oracle to MS SQL and viceversa. We have a product that runs on MS SQL and Oracle. Let's say we wrote a script to derive information from a specific DB in MS SQL, we want to be able to simple convert the script to run on Oracle, since both DBs independent of Oracle or MS SQL contain the same information, the problem lies in the syntax of the script as they differ from one DB to the other.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ive used Microsoft SQL Server Migration Assistant (SSMA) for Oracle, it successfully translated (approximately) 70% of PL/SQL code (some procedures/functions are very complex)
http://www.shareup.com/MSSQL-to-Oracle-download-15557.html