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?
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