Table and Data Conversion
Ispirer Toolkit converts tables with all related objects (indexes, referential integrity constraints) and data into the target Azure SQL Database. All PostgreSQL native data types are converted to the Azure SQL Database equivalent. If necessary, the user can change the default settings of data type mapping.
Procedure and Function Conversion
PostgreSQL user procedures and functions are converted to stored procedures and functions, written in Azure SQL syntax, depending on the version of the target database. PL/PgSQL built-in functions and procedures are converted to theirs equivalents in Azure SQL DB. If there is none, the tool will try to convert the functions to SQL Azure expressions. They will emulate the same behavior or generate user-defined function that will work the same as in the PostgreSQL database.
Ispirer Toolkit automatically migrates PostgreSQL triggers and their functions to Azure SQL Database triggers. PostgreSQL trigger logic is moved to the trigger function as well. The trigger name in the target database will be the same as in PostgreSQL.
Working with User Defined Types
Ispirer Toolkit supports conversion of user defined types to their equivalents in Azure SQL Database.
PostgreSQL sequences are converted to Azure SQL DB sequences. This is the default behavior of the migration tool.