*** Readme.txt File for the SSCESyncDesignerTest Sample Application ***

Important: The SSCESyncDesigner Test Harness described in the article and in the OakLeaf Systems "A Sync Services Bidirectional Test Harness" blog post (http://oakleafblog.blogspot.com/2007/03/sync-services-bidirectional-test.html) has a problem with Beta 1. Check this post periodically for the availability of a workaround or more details on the Beta 1 issue(s).

THIS SAMPLE APP RUNS ONLY UNDER ORCAS BETA 1

The "Update Local Data Caches with Sync Services" article in the May 2007 issue of "Visual Studio Magazine" was written when the Orcas March 2007 Community Technical Preview was current. Subsequently, Microsoft released Orcas Beta 1, which was used to create this code. Several Sync Services bugs and warts were fixed in Orcas Beta 1:

1. You now can save changes to the DataSet generated by the Sync Designer, so the Orders and Order_Details TableAdapters were added to the NwindOCS DataSet instead of creating a new ServerDataSet.

2. The inoperable timed synchronization option has been removed from the Designer.

3. The Designer now has a button that opens a dialog, which lets you copy the two required lines of synchronization code to the clipboard.

The name of the SQL Server Express database has been changed to NwindOCS to prevent conflicts with existing Northwind sample databases. The connection string for the server is in App.config and defaults to Data Source=.\SQLEXPRESS;Initial Catalog=NwindOCS;Integrated Security=True.

To install and run this project, do the following:

1. Unzip the files with Use folder names to a directory of your choice.

2. Move the NwindOCS.mdf and NwindOCS_log.ldf files from the \SSCESyncDesignerTest folder to your SQL Server Express Folder (usually \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) and then use SQL Server Management Studio to attach the files to your SSX instance.

3. Open SSCESyncDesignerTest.sln in Visual Studio "Orcas" Beta 1, and press F5 to build and run the project.