Friday, April 6, 2007

Ocassionally Connected Systems

OCS, Occasionally Connected Systems, is a framework that has been added in Microsoft Visual Studio Codename Orcas (or Visual Studio 2007). It facilitates the user to download data from a remote database server onto the client machine and then use it offline (i.e. without going to the database server again and again). The data would be synchronized by the OCS automatically after a specific interval.

OCS uses SQL Compact (earlier known as SQL Server Mobile Edition or SQL Server Compact Edition)to store and manipulate data. OCS allows the user to add new tables, remove already added tables and provides multiple options for the synchronization process.

The synchronization requires some changes to be made in the database scheme at the server side. Both the SQL Scripts and the SQL Undo Scripts are provided and can be used in order to undo every change that OCS has made in the schema.

OCS is going to be shipped in the Visual Studio 2007 Beta 1. I am open to accept comments/feedback regarding OCS from you. You can rely on me as a mean to transfer your concerns to the Microsoft Visual Basic Team. Waiting for your responses

No comments: