• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2357
  • Last Modified:

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?
0
ebetancourth
Asked:
ebetancourth
  • 2
  • 2
1 Solution
 
mj_norwichCommented:
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
0
 
ebetancourthAuthor Commented:
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.
0
 
mj_norwichCommented:
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)
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now