PostgreSQL to SQL Server converter implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into MS SQL database only those records whose key/index value does not exist in the destination table. Otherwise, PostgreSQL-to-MSSQL appends the whole table contents to the corresponding MS SQL table. If the structures of source and destination tables are different, the program transforms each record of the source table so that it conforms to the destination table structure.
If structures of PostgreSQL and MS SQL tables are distinguished, the converter attempts to transform every row so that it conforms to SQL Server table structure.
Have more questions? Contact us