Conflict resolution mechanisms are provided, but at any given time, the database is not guaranteed to be consistent, as is the case with SQL Server. Partial replication of Microsoft Jet databases, where entire tables or just those rows that meet specified criteria, such as Western region sales or New York customers, was introduced in Microsoft Jet 3.5. SQL Server 6.5 supports partial replication both at the row and column level. The FoxPro engine supports full and partial table replication in Visual FoxPro 5.0, through the Offline View feature. Offline Views are local, updateable snapshots of FoxPro engine views and can be based on local or remote data.
Scheduled synchronization requires additional coding.
In addition, SQL Server offers Quick Fix Engineering, offering customer-specific fixes for identified problems. Inc. All Rights Reserved.