https://convert-db.com/mssql-to-oracle/
Migrating MSSQL to Oracle 1. Pre-Migration Assessment Evaluate the Database Schema and Size: Review the schema, relationships, data types, and triggers in your MSSQL database. Note differences in data types, constraints, and stored procedures. Identify Compatibility Issues: MSSQL and Oracle differ in SQL syntax, functions, and database objects. Make a list of features in MSSQL that might not translate directly to Oracle. Prepare for Downtime: Large databases or complex migrations might require downtime. Ensure proper planning for minimal impact.