Oracle to Microsoft SQL Server Migration

Ispirer Toolkit automates the entire migration of database objects from Oracle PL/SQL to Microsoft SQL Server. Both conversion with connection to the source database, as well as conversion of files containing Oracle 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 Toolkit can migrate the following objects: tables, views, functions, procedures, packages (specification and body), triggers and sequences, collection and object types. As a result of conversion, each separate database object is converted to its equivalent in Transact-SQL.

If you have your own applications, the Embedded SQL and Database APIs can be converted using either Ispirer Toolkit or Ispirer Service. As a result, they will be able to work with your new Microsoft SQL Server database.

Table and Data Conversion
Ispirer Toolkit converts tables with all related objects (indexes, referential integrity constraints) and data to the target Microsoft SQL Server database. All Oracle native data types are converted to the SQL Server equivalents. If necessary, the user can change the default settings of data type mapping.

Procedure, Function and Trigger Conversion
Oracle user procedures, functions and triggers are converted to stored procedures, functions and triggers written in T-SQL syntax, depending on the version of the target database. Packages are converted to a separate set of objects - procedures and functions in T-SQL. Package-level variables and constants are taken into account by Ispirer Toolkit as well. They are migrated to tables in which actual values are stored. Moreover, an additional set of user-defined functions will be automatically generated. They will work only with such tables. These UDFs will be able to set and update values in such tables. Transact-SQL built-in functions and procedures are converted to their equivalents in SQL Server. If there is none, the tool will try to convert the functions to T-SQL expressions. They will emulate the same behavior or generate a user-defined function that will work the same way as in the Oracle database.

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

Oracle Supplied PL/SQL Package Conversion
Ispirer Toolkit 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.