Home > Documentation > MS SQL to PostgreSQL

Merging MS SQL data into the PostgreSQL database

SQL Server to PostgreSQL converter implements merging according to the following algorithm. If both source and destination tables have primary key or an unique index, the program appends those records whose key/index value does not exist in PostgreSQL table. Otherwise, all rows from the source table are appended.

If structures of MS SQL and PostgreSQL tables are distinguished, the converter attempts to transform every row so that it conforms to PostgreSQL table structure.

Have more questions? Contact us