MSSQL-PostgreSQL Sync

MSSQL-PostgreSQL Sync is a program to synchronize data between SQL Server or Azure SQL and PostgreSQL databases. The tool requires source and target database exist and have equal structures (synchronized tables must have the same columns and primary key or unique index defined). If you do not have PostgreSQL database yet, use SQL Server to PostgreSQL converter to create it from the source SQL Server or Azure SQL database.

Features All versions of Microsoft SQL are supported (including Azure SQL) All versions of Linux/Unix and Windows PostgreSQL servers are supported Option to synchronize individual tables Bi-directional synchronization: MS SQL->PostgreSQL or PostgreSQL->MS SQL Support for incremental synchronization Command line support Stores configuration into profile Quick Launch The product can be customized according to customer requirements Unlimited 24/7 support service 1-year subscription for updates

Requirements

• Necessary privileges to created triggers in source database and to write into both source and destination databases
• Source and target databases must contain tables being synchronized, with equavalent structures and primary key or unique index defined. You can use SQL Server to PostgreSQL and PostgreSQL to MS SQL converters for initial migration
• SQL Server environment (server or client components of SQL Server should be installed on the same machine where you run MSSQL-PostgreSQL Sync from)
• Supported OS: Windows 7/8/10/11, Server 2008/2012/2016/2019/2022, Linux with WINE (contact us if you need version for Windows XP or Server 2003)

Limitations

• Demo version synchronizes not more than 50 rows per table

How does it work

MSSQL-PostgreSQL Sync works according the following scheme. When running synchronization for two particular databases at first time:

• the program does full synchronization for each of selected tables from source and destination databases (inserts into destination table missing rows from the source, updates existing rows and deletes from destination table all rows missing in source table)
• the program creates all necessary service objects for incremental synchronization in next run (table to store changes and triggers on insert, update and delete for each table being synchronized)

When running synchronization next time, the program processes only data being changed in each table using incremental synchronization technique mentioned above.

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.m_s) file with left mouse button. This will cause MSSQL-PostgreSQL Sync wizard to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to synchronize only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.

Ordering

For online credit card purchasing select the appropriate option in the table below and click the corresponding "BUY NOW" link. MSSQL-PostgreSQL Sync is covered by 30 day money-back guarantee.

MSSQL-PostgreSQL Sync Single User License	$59	BUY NOW
MSSQL-PostgreSQL Sync Corporate License	$149	BUY NOW
SQL Server to PostgreSQL tool for initial database migration	$59	BUY NOW
Two Products Bundle buy MSSQL-to-PostgreSQL + MSSQL-PostgreSQL Sync, save $35.40	$82.60	BUY NOW