Microsoft provides increased support for occasionally connected clients with Service Pack 1 for Visual Studio 2008. The DataSet designer has been enhanced to integrate more tightly with ADO.NET Sync Services and SQL Server 2008 Change Data Capture. If SQL Server 2008 or CDC is not available, the designer still allows the option to generate a SQL script for manual change tracking.
The DataSet Designer has been enhanced to allow data sources to be switched from connected to disconnected with zero code changes. This allows tables coming from a server data store and tables coming from a client data store to be represented within one model.
Sync Services for ADO.NET is a part of Microsoft Sync Framework, "a synchronization platform enabling collaboration and offline access for applications, services, and devices."
SQL Server 2008 Change Data Capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in consumable relational format. "The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred."
The DataSet Designer has been enhanced to allow data sources to be switched from connected to disconnected with zero code changes. This allows tables coming from a server data store and tables coming from a client data store to be represented within one model.
Sync Services for ADO.NET is a part of Microsoft Sync Framework, "a synchronization platform enabling collaboration and offline access for applications, services, and devices."
SQL Server 2008 Change Data Capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in consumable relational format. "The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred."