SQL Server Express 2008 replication/synchronisation

We are considering creating a tiny, straightforward, Access system for a customer making use of SQL Server Express (2005 or 2008) as data source. The only complicating variable is they have 2 workplaces and also they will certainly require to synchronise some (yet not all) information in between them.

What are my alternatives with the Express version for doing this? Exists any kind of benefit to making use of 2008 over 2005?

0
2019-05-13 03:52:29
Source Share
Answers: 2

SQL Server Express 2008 (and also SQL Server Express 2005) can just work as replication subscriber. I do not recognize the information of your application, yet you possibly can write your very own synchronization device.

0
2019-05-17 10:55:54
Source

You can make use of the Change Tracking attribute. It is made to permit periodically - linked systems to sync up by just fetching the information that is transformed given that the last sync. Check Out my TechNet Magazine write-up Tracking Changes in SQL Server 2008 for a starter - great deals of BOL web links. http://www.sqlskills.com/BLOGS/PAUL/post/TechNet-Magazine-Article-on-Tracking-Changes-in-Your-Enterprise-Database.aspx

0
2019-05-17 10:12:56
Source