Migrate Microsoft SQL Server to PostgreSQL

Automated Database Migration

Need to migrate Microsoft SQL Server to PostgreSQL? In this case, Ispirer migration tools and services will be the perfect solution for your project!

Ispirer Migration and Modernization Toolkit (Ispirer MnMTK)

Ispirer MnMTK is a high-class software that automatically migrates SQL Server to PostgreSQL. It converts the entire database schema (tables and SQL objects), as well as transfers data. Besides, such a challenging and most time-consuming task as database business logic conversion is greatly facilitated due to the power and flexibility of the Ispirer tool. As a result, you significantly reduce overall effort and time for migration. You can check all these features for yourself with the free demo of Ispirer MnMTK.
Each project has its own specifics. It may seem impossible to bring migration automation to a high level. With Ispirer it will be a smooth transition. The main advantage of Ispirer MnMTK is the personalization for your migration project. We will add all conversion rules to achieve up to 100% automated migration from your SQL Server database to PostgreSQL through customization.

Ispirer MnMTK 2020
SQL Server to PostgreSQL
Free Demo License

Try now

Migration Overview

Ispirer MnMTK automates the entire migration of database objects from SQL Server to PostgreSQL. Both conversion with connection to the source database, as well as conversion of files containing Transact-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 and data, views, functions, procedures, triggers, sequences, user-defined types. As a result of conversion, each separate database object is converted to its equivalent in PostgreSQL.

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

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

Procedure and Function Conversion
SQL Server user procedures and functions are converted to stored procedures and functions, written in PostgreSQL syntax, depending on the version of the target database. Transact-SQL built-in functions and procedures are converted to their equivalents in PostgreSQL. If there is none, the tool will try to convert the functions to PL/PgSQL expressions. They will emulate the same behavior or generate a user-defined function that will work the same way as in the SQL Server database.

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

Working with User-Defined Types
Ispirer MnMTK supports conversion of user-defined type to its equivalent in the PostgreSQL database. According to the type and its usage, it may be converted to a user, native type, or to a 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 SQL Server synonyms to the original object names in places where they are used in the 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.

In addition to PostgreSQL, Ispirer can offer you migration from Microsoft SQL Server to other databases, including:

Microsoft SQL Server to PostgreSQL Migration Demo

Check out how you can automatically migrate Microsoft SQL Server to PostgreSQL database with the help of Ispirer MnMTK.

Drop us a line, if you have any business inquiries or questions regarding your Microsoft SQL Server to PostgreSQL migration project. Ispirer experts will provide support and answer any questions you may have!

Get a Quote

Ispirer MnMTK

Reach the maximum level of automation and quality of conversion from Microsoft SQL Server to PostgreSQL with the help of Ispirer Migration and Modernization Toolkit! Based on your requirements, the Ispirer team will process all Extension Requests for your Microsoft SQL Server to PostgreSQL conversion project. We offer several types of Ispirer MnMTK licenses, among which you will find the one that is suitable for you. Each conversion project is considered and discussed separately, prices depend on its scope, duration and complexity.

Ispirer MnMTK 2020
SQL Server to PostgreSQL

Request a Quote

Ispirer Service

If you don't want to involve your own resources to move Microsoft SQL Server to PostgreSQL, get Ispirer Migration and Modernization Service and we will deliver you an operational and high-quality end-result on time and at a reasonable price. Apart from professional Analysis, Evaluation, Performance and Testing of your migration, we also provide such services as Code Refactoring, Changing Functionality, and Adding Extra Functionality. Each conversion project is reviewed and discussed separately and the final price is a subject to negotiation.