Migrating SQL Language Support from Oracle to SQL Server

Recommended Conversion Strategy

Use the following checklist when migrating your Oracle DML statements and PL/SQL programs to Transact-SQL:

1. Verify that the syntax for of all SELECT, INSERT, UPDATE, and DELETE statements is valid. Make any required modifications.
2. Modify all outer joins to SQL-92 standard outer join syntax.
3. Replace Oracle functions with the appropriate SQL Server functions.
4. Verify all comparison operators.
5. Replace the “||” string concatenation operators with the “+” string concatenation operators.
6. Modify all PL/SQL cursors to either noncursor SELECT statements or Transact-SQL cursors.
7. Replace or convert PL/SQL procedures, functions, and packages with Transact-SQL procedures.
8. Convert PL/SQL triggers to Transact-SQL triggers.