MSSQL to PostgreSQL

Migrating from one database server to another poses a few risks that you might not be willing to take, mainly related to data loss and compatibility. Luckily, there are applications that provide step-by-step guidance for transitioning to a different server, so that all the incompatibility issues are addressed.

One such example is the MSSQL to PostgreSQL application which, as the name suggests, can help you migrate from SQL Server to PostgreSQL, exporting database schemas, tables, data, indexes and much more. All versions of SQL Server and PostgreSQL are supported.

The application adopts a wizard-based approach, providing assistance in migrating the SQL Server database to PostgreSQL.

Before going further with the wizard, please make sure you have enough privileges to read the MS SQL schema and the database contents, to create objects and to insert data into PostgreSQL. Needless to say, you must be able to connect to both database servers.

MSSQL to PostgreSQL can migrate the data either to PostgreSQL server directly or to a script file that can then be imported into PostgreSQL. The first steps require you to connect to running instances of Microsoft SQL Server and PostgreSQL. Once connected, you must choose the elements to migrate.

The application can convert tables, indexes, sequences, constraints and views, as well as spatial data. You can use SELECT queries to filter data and customize field mapping. If you already have a PostgreSQL database, this can be overwritten, synced or merged with the data from SQL Server.

The wizard-based approach of MSSQL to PostgreSQL makes this application easy-to-use, while the high-performance conversion engine ensures a fast migration rate. According to the developer, a 2,5 GB database is migrated within less than 20 minutes on an average system.