Post reply

SQL Server 2008 R2 Express Sync

  • October 19, 2012 at 3:27 am

    #283864

    Hello

    I have been tasked with finding a method of synchronizing offsite branches to the HQ.

    It will be one-way synchronization of certain tables from the remote branches databases to the HQ database. The databases from the remote sites and HQ have the same schema.

    The data will require to be synchronized every minute and the data size is less than 100KB.

    Ideally what should only be synchronized are the differentials (new data in the specified tables).

    Finally the branches and the HQ are running Server 2008 R2 Express.

    My questions are:

    Can this be achieved with the Express edition?

    If not, will I have to implement some powershell, export, import thing? (Guessing here)

    What type of replication would it be best suited for this?

    Or are there any 3rd party utilities out there than can achieve the required result?

  • October 29, 2012 at 3:47 pm

    #1553935

    I think replication will be good for what you need, but SQL Server Express Edition database Servers can only be subscribers. You may want to change the edition of your HQ database Server.

    http://www.sql-server-performance.com/2010/sql-server-2008-r2/



    My blog

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

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