Sunday, May 9, 2010

Recent Synchronization and Replication advice from Microsoft bloggers

This is a round-up of some recent blog entries from Microsoft relating to Sync and Replication.

Merge Replication

The Microsoft SQL Server Replication Support Team has started a blog which includes excellent Merge Replication advice. Start at this overview blog entry.

In addition, Rob Tiffany has made a list of SQL Compact Merge Replication performance tips available here. This list is a summary of some of the advice in Robs excellent Merge Replication book. It even includes some of the improvements in SQL Compact 3.5 SP2, including the new PostSyncCleanup property of the SqlCeReplication object, and highlights the new support for Windows 2008 R2 with IIS 7.5 included with the SP2 server tools.

Sync Services

The Sync Services team has published a useful FAQ. And the SQL Support team blog has a long walkthrough of setting up N-tier Sync Services for ADO.NET.

7 comments:

kamil nowicki said...

i wasn't aware of this ms blog you mentioned. some great stuff there, thanks for sharing.

Joni Loveless said...

I am new to using SQL compact wondering if you can answer a question for me. I have created an application that resides on one computer. Other computers can access the application across the network (and at the same time) but all files do reside on one computer. Can I use compact for this type of setup? Can i have more than 1 user updating the database at a time?

ErikEJ said...

Joni: The short answer is no, as access to SQL Compact files over the network is not allowed. It is better to use SQL Express for these scenarios

Joni Loveless said...

Thank you Erik I have been trying to get this question answered for some time.

Joni Loveless said...

Erik one more question...could you make any recommendations for a SQL database that can be embedded in an application but can also be accessed over a network by more than 1 user?

ErikEJ said...

Microsoft Access??

Olawale said...

Hello ErikEJ
I am relatively new in sqlce and mobile application. My question is how best can I transfer records captured on the field with windows mobile application using sqlce as backend to ms sql server 2005 and above? Many field officers use the mobile device to capture data on the field and cradle their devices as soon as they come back so that the records captured on the field could be transfered to the main server and immediately purge sqlce records after successful transfer