Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 Express Sync Expand / Collapse
Author
Message
Posted Friday, October 19, 2012 3:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 22, 2012 5:44 AM
Points: 1, Visits: 8
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?
Post #1374702
Posted Monday, October 29, 2012 3:47 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, October 13, 2014 11:46 AM
Points: 3,087, Visits: 1,436
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
Post #1378493
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse