Tuesday, November 18, 2008

SQL Compact data and schema export utility on CodePlex

I have made some modifications to the utility I blogged about here and made the code available as a project on CodePlex. Please feel free contribute feature requests, patches and bug reports. The utility exports the object definition from a SQL Compact database, including tables, indexes, foreign keys and other constraints. It also scripts INSERT statements for all the data in the SQL Compact table (currently missing features are support for INSERT to image columns, and proper creation of IDENTITY columns).

Tuesday, November 4, 2008

New edition of Merge Replication book

Rob Tiffany has begun a new edition of his excellent Merge Replication book, the new title is:

Mobile Data Synchronization with Microsoft SQL Server 2005 and SQL Server Compact > Second Edition. Achieving Global Scalability via Merge Replication Republishing.

Go download and read Chapter 1.