Databases Reference
In-Depth Information
With the database registered, but not provisioned, the next step is to configure the sync group to define the data
to be synchronized and the Conflict Resolution policy.
Selecting Tables to be Synchronized
Significant enhancements have been made to SQL Data Sync since the last edition of this topic, including how
the sync dataset is defined. In the Configuration section of the Sync Group window, click the Edit Dataset button,
which will display the Define Dataset dialog. This dialog is quite powerful, in that you can select not only the tables
to be synchronized, but also the columns of each table. Additionally, row filtering can be applied to the dataset to
synchronize specific data. In this example each of these features will be illustrated.
As you scroll through the list of tables you will notice that some are red. You should also notice a nice red warning
at the top of the dialog stating the some of the tables do not meet schema requirements.
Tables that appear in red cannot be selected for synchronization. This example will select two tables that are OK for
synchronization; HumanResources.Employee and Person.BusinessEntity. As you select the HumanResources.Employee
table, you'll notice that even though the table itself is not red (OK for synchronization), some of the columns are red. That
means that those columns cannot be selected and are not available for synchronization. You can see this in Figure
7-12
.
Figure 7-12.
Selected tables and columns to be synchronized, and two columns that cannot be selected
