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