Database migrations impact applications in many ways. Most common changes to applications include:
Connection mechanisms including using vendor-specific drivers. Database drivers from different vendors have different connection string formats and parameters that they support.
Applications have to be modified to issue vendor-specific (Oracle) SQL Statements. Such modifications may be minimal if the application uses ANSI standard SQL Statements. For example, SQL Statements with database-specific extensions such as date/timestamp arithmetic need modification.
The database access APIs from different vendors differ on how they allow manipulation of cursors, LOBs, system-generated keys, and so on.
Error handling may also require manual intervention as databases have different error codes for the same error condition. This task is easier to accomplish if the application uses a central library of error codes and messages so that the full application code...