Merging SQL Server 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. If such transformation is not possible, the program will fire an error.

Have questions? Contact us