Setup Scripts for Database Provider How-to Topics
The following scripts create databases and tables that are used in the Sync Framework how-to topics and samples:
The first script creates two tables that are used for collaborative scenarios in which SQL Server and SQL Server Compact are synchronized:. For more information, see How to: Execute Database Synchronization (SQL Server).
The second script creates a custom change tracking infrastructure that is used for offline-only synchronization scenarios. For more information, see How to: Use a Custom Change Tracking System.
The third script enables the change tracking feature that was introduced in SQL Server 2008. This script is also used for offline-only synchronization scenarios. For more information, see How to: Use SQL Server Change Tracking.
The fourth script creates a change-tracking infrastructure that is used for some collaborative synchronization scenarios. For more information, see How to: Provision a Server Database for Collaborative Synchronization (Non-SQL Server).
The scripts have been tested with SQL Server 2008.