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 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.
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.
Topics
- Migrate Applications from PostgreSQL Databases to Autonomous Database
You can migrate SQL statements from PostgreSQL to Oracle SQL and run the statements on Autonomous Database. - Migrate Applications from MySQL Databases to Autonomous Database
You can migrate SQL statements from MySQL to Oracle SQL and run the statements on Autonomous Database. - Migrate Applications from SQL Server Databases to Autonomous Database
You can migrate SQL statements from SQL Server to Oracle SQL and run the statements on Autonomous Database.
Parent topic: Migrate to Autonomous Database