Migrate Applications from Non-Oracle SQL to Oracle SQL

Application migration involves moving an application from one environment to another. The migration process includes a variety of tasks, including migrating SQL statements from a non-Oracle database to Oracle SQL.

The DBMS_CLOUD_MIGRATION package facilitates the translation of SQL statements written for a non-Oracle database to Oracle SQL. This allows you to easily migrate applications to Autonomous AI Database, when the applications were developed for non-Oracle databases that use a different SQL flavor.

The DBMS_CLOUD_MIGRATION package supports migration of SQL code from the following non-Oracle databases:

• PostgreSQL

• MySQL

• SQL Server

The DBMS_CLOUD_MIGRATION package provides routines that allow you to:

• Translate individual SQL statements from a non-Oracle database to Oracle SQL.

• Translate files containing SQL code from a non-Oracle database to Oracle SQL, and generate a new file containing the translated Oracle SQL.

• Work interactively in a session, entering SQL statements from a non-Oracle system. In this case, the non-Oracle statements are translated and run interactively in your session.

Note: To run the subprograms in DBMS_CLOUD_MIGRATION you must be logged in as the ADMIN user or have EXECUTE privilege on DBMS_CLOUD_MIGRATION.