Link to home
Start Free TrialLog in
Avatar of Edwin Betancourth
Edwin BetancourthFlag for United States of America

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?
Avatar of sonicefu
sonicefu
Flag of Pakistan image

Avatar of mj_norwich
mj_norwich

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
Avatar of Edwin Betancourth

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
Avatar of sonicefu
sonicefu
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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)