• Product Information
  • About
  • News
  • Screenshots
• Support Information
  • Documentation
  • FAQ
  • Support
  • Upgrade policy
• Download
• Purchase

Download Buy

MS SQL Data Sync online Help

How to connect to Microsoft SQL

To compare two Microsoft SQL databases you need to connect to them first. Specify connection properties of the Source database and the Target database. In this case MS SQL Data Sync after the comparison prepares a synchronization script to be executed on the target database. To compare tables stored in one database, specify the connection properties once and use the Copy source to target or Copy target to source buttons.

MS SQL Data Sync allows you to connect to Microsoft SQL servers using Windows and SQL Server authentication modes.

Provider

The application allows you to connect to SQL Server using any of SQL Server Native Clients installed on your computer. To choose a client you want to use, select the appropriate item in the Provider combobox. The table below shows the correspondence between the value selected in this combobox and SQL Server client to be used.

We would recommend you to install and use SQL Server 2012 Native Client as it (and only it) supports SQL Server Express LocalDB. Also it provides the best support for data types implemented in the recent versions of SQL Server.

Windows Authentication (more preferable)

Microsoft Windows Authentication mode allows a user to connect through a Windows user account.

SQL Server Authentication

When a user connects with a specified Login name and Password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded.