Post reply

Sync data between office and laptop copies of database

  • December 21, 2010 at 11:30 am

    #244647

    I have been asked to build an application that allows multiple users but without online access. The company does not always have Internet access when in the field, so they want multiple copies that synchronize. I will be using ASP.NET to build the interface and SQL Express to store data on both the main database, which will be stored in-house, and the duplicates which will be on several laptops.

    I have the skills to build the application, but what I don't know is how to sync the data between the main database and laptop copies. Howe do I identify which records to INSERT or UPDATE? Is there a comparison script? Do I need a flag field and if so, how would I use it?

    Please bear in mind, I'm not a SQL guru...

    Thanks much!

    Janice

  • December 22, 2010 at 9:21 am

    #1265578

    I have a similar situation and have been using SQL Server Merge Replication to synchronize SQL Express databases on laptops and SQL Compact databases on Windows Mobile devices. It does require some research and experience to perfect the use of Merge Replication, but in the end, it does a good job. You may want to start here: http://msdn.microsoft.com/en-us/library/ms152746.aspx

    Good luck!

  • December 22, 2010 at 12:52 pm

    #1265664

    Thanks, Steve. I'll check it out.

    Does anyone know of a book or tutorial that will shorten the learning process? I need to get this up ASAP. Thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply