Migrating SQL DB to Oracle DB

Oracle has the SQL Translation Framework which also integrates with Oracle's SQL Developer tool.

https://blogs.oracle.com/imc/sql-translation-framework-in-oracle-database-12c

Interesting, I've only been involved in the migration the other way Oracle to MS.....cost driven decisions.
What was the thought process of shifting the other way? Just curious.

Tony

I haven't ever used the tool that sdstuber mentioned, but most conversion tools aren't able to convert or translate 100% of the code from one system to another.  Usually at least some manual conversion and/or re-writing is required especially if the code in the source systems uses some features that are unique to that system.

Also keep in mind the fact that record locking and data concurrency is handled very differently by Oracle than by SQL Server, so code optimized for one of these systems may not be required in the other, or may need to be quite different in the other.  A related difference is whether temporary tables are required, or not.  In SQL Server these are often required and are created dynamically in stored procedures.  In Oracle, these are usually not required and are certainly not created dynamically by stored procedures.  In Oracle these are created just once, usually via *.sql scripts executed manually by a DBA or developer, then are referenced by stored procedures when needed.