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 wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

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

One-click re-compare

MS SQL Data Sync allows to save all options to a project file for instant re-execution.

Command line interface

MS SQL Data Sync supports a number of command-line options that make it possible to fully automate all the data synchronization routines.

MS SQL Data Sync online Help

Auto mapping

Christmas Sale