Databases Reference
In-Depth Information
Figure 7-18.
Data validation
Editing Data and Resynchronizing
Now let's edit some data and resynchronize, and then validate that the changes were made by requerying the data.
Go back to SQL Server Management Studio and open a query window to the on-premises member database AW2012.
Type in the following query:
UPDATE HumanResources.Employee SET Job Title = 'Head Geek' WHERE BusinessEntityID = 1
Open up another query window connected to the SQL Database member instance and execute the
following query:
UPDATE HumanResources.Employee SET Job Title = 'VP of Techy Stuff' WHERE BusinessEntityID = 2
Instead of waiting for the scheduled sync to pick up, click the Sync Now button on the toolbar. The
synchronization should only take a few seconds, at which point you should be able to query the HumanResources.
Employee table in the hub database and validate that the changes made to the member databases where indeed
synchronized to the hub database.
Testing Conflict Resolution
In this example the Conflict Resolution was set to Hub Wins. For a quick test, change the Conflict resolution to Client
Wins and deploy the changes. Once the deployment is done, go back to SQL Server Management Studio and execute
the following query against the on-premises database:
UPDATE HumanResources.Employee SET Job Title = 'Chief Executive Officer' WHERE BusinessEntityID = 1
Wait 1 minute and then execute the following query against the SQL Database member instance:
UPDATE HumanResources.Employee SET Job Title = 'Chief Head Officer' WHERE BusinessEntityID = 1
Manually resynchronize; this should only take several seconds. Once the sync is done, query the
HumanResources.Employee table in both the hub database and the on-premises member database. The value of the
Title column for BusinessEntityID 1 should now be “Chief Head Officer” in all three locations.
