Recommended Conversion Strategy

Use the following process when you convert your application code from Oracle to SQL Server:

1. Consider converting your application to ODBC if it is written using Oracle Pro*C or the Oracle Call Interface (OCI).
2. Understand SQL Server default result sets and cursor options, and choose the fetching strategy that is most efficient for your application.
3. Remap Oracle ODBC SQL data types to SQL Server ODBC SQL data types where appropriate.
4. Use the ODBC Extended SQL extensions to create generic SQL statements.
5. Determine if manual commit mode is required for the SQL Server application.
6. Test the performance of your application(s) and modify the program(s) as necessary.