MS SQL Data Sync online Help

Return to chapter overview

MS SQL Data Sync automatically maps tables with the same names, but you can adjust auto mapping rules more carefully. Check the corresponding boxes to set Data Sync to ignore autoincrement, timestamp, BLOB, and GUID columns.

Ignore columns by mask

You can also set a mask to for column names to be ignored. Suppose, you have several columns such as 'user_last_modified', 'country_last_modified' and so on, those are not to be synchronized. Specify the mask as follows to ignore these columns on auto mapping.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

Mar 20, 2024

Data Syncs have been upgraded

New version comes with support of all the modern database server versions available at the moment.

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Apr 11, 2016

Data Syncs 16.4 released

This version introduces cross-DBMS data comparison with native support for the most popular database servers, email notifications, and more.

More news

Feature of the day

Custom comparison key

MS SQL Data Sync allows you to specify the comparison key to compare tables.

Data differences view

With MS SQL Data Sync you can analyze the result of database contents comparison using difference elimination, sorting, and filtering.

MS SQL Data Sync online Help

Auto mapping

Thanksgiving Sale