Migrar Oracle a Amazon Aurora PostgreSQL

Ispirer MnMTK automates the entire migration of database objects from Oracle to Amazon Aurora PostgreSQL. Both conversion with connection to the source database, as well as conversion of files containing PL/SQL scripts are possible. The first option is most recommended, as the tool will get all the required information about object dependences directly from the database. Ispirer MnMTK can migrate the following objects: tables, views, functions, procedures, packages (specification and body), triggers, sequences, collection and object types. As a result, each separate database object is converted to its equivalent in Aurora PostgreSQL.

Table and Data Conversion
Ispirer Migration and Modernization Toolkit converts tables with all related objects (indexes, referential integrity constraints) and data to the target Amazon Aurora PostgreSQL database. All Oracle native data types are converted to the Aurora PostgreSQL-compatible equivalent. If necessary, the user can change the default settings of data type mapping.

Procedure and Function Conversion
Oracle user procedures and functions are converted to stored procedures and functions, written in Aurora PostgreSQL syntax, depending on the version of the target database. Packages are migrated to a separate set of objects - procedures and functions. Ispirer MnMTK supports conversion of package-level variables and constants as well. The tool converts them to tables that store the actual values, and a set of functions that define and get values of those tables. Oracle built-in functions and procedures are converted to their equivalents in Amazon Aurora PostgreSQL. If there is none, the tool will try to convert the functions to Aurora PostgreSQL expressions. They will emulate the same behavior or generate a user-defined function that will work the same way as in the Oracle database.

Trigger Conversion
Ispirer MnMTK automatically migrates Oracle triggers to the trigger function, and the trigger itself to the Amazon Aurora PostgreSQL database. Oracle trigger logic is moved to the trigger function as well. The tool then generates a trigger that calls this trigger function.

Working with Collections and their Methods
Ispirer MnMTK supports collection conversion of all three types: Associative array, Nested table, Variable-size array (varray). They are converted to a Aurora PostgreSQL table. Then a set of user-defined functions is generated. This allows to work with values in such tables.

Alias Conversion
The Ispirer toolkit migrates Oracle synonyms to the original object names in the places where they are used in the Amazon Aurora PostgreSQL code. This is the default behavior of the tool. Moreover, if the Oracle database has synonyms only for tables, Ispirer MnMTK can convert them to views by setting the appropriate option.

Oracle Supplied PL/SQL Package Conversion
Ispirer MnMTK supports conversion of some Supplied PL/SQL Packages, such as UTL_FILE, DBMS_LOB and others. The list can be expanded depending on the requirements of your conversion project.