Track SQL CE TrackSqlCe is a device component that tracks changes made to a SQL CE 2.0 / SQL Mobile database.
Download

Track SQL CE Ranking & Summary

Track SQL CE Tags

tracks database dvd to ce device dvd to ce mobile business component developer ce

Track SQL CE Description

Track SQL CE is a device .NET Compact Framework component that quickly and accurately tracks changes to SQL CE 2.0 and SQL Mobile database (Mobile video converter software)s. With a single call, your application can quickly determine which rows were INSERTed, UPDATEd or DELETEd since the last checkpoint. What is Track SQL CE? TrackSqlCe is a device component that tracks changes made to a SQL CE 2.0 / SQL Mobile database. Before tracking can be made, the database must be prepared. After preparation, the component will be able to determine which rows were inserted, updated or deleted in the set of tracked tables. What happens during preparation? During preparation, three tables are added to the database: MSysSyncTables: Contains all the tracked tables MSysSyncRows: Contains a CRC32 value and the created GUID for each row of each tracked table MSysSyncGen: Counts the number of track 'generations' Also, for each tracked table, two columns are added: s_guid: A GUID (uniqueidentifier) that uniquely identifies the row s_gen: The generation of the row (zero when inserted) What happens during tracking? During the tracking procedure all rows of all tracked tables are compared (via CRC32 calculation) to the corresponding row in MSysSyncRows. If the CRC32 value is equal then the row has not been updated. If the CRC32 value is different, then the row was updated. To detect row insertions, the s_gen column of the tracked tables is searched for zeroes. To detect deletions, GUID values are compared between MSysSyncRows and the tracked tables. How do I know what changed? The s_stat column of the MSysSyncRows table contains all four possible states for a given row: 0: No change 1: The row was inserted 2: The row was updated 3: The row was deleted You can get the list of updated rows with the following SQL command: SELECT MSysSyncTables.s_tableName, MSysSyncRows.s_stat FROM MSysSyncTables INNER JOIN MSysSyncRows ON MSysSyncTables.s_tableID = MSysSyncRows.s_tableID WHERE MSysSyncRows.s_stat > 0 What databases are supported? Track SQL CE supports both the SQL CE 2.0 and SQL Mobile (3.0) engines on the same component. How is the product licensed? Track SQL CE is licensed per developer seat. Distribution of the component integrated in a consuming application is royalty-free. Platforms supported:Win CE / Pocket PC

Track SQL CE Related Software