Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication between two SQL 2012 Express DBs using SMO Expand / Collapse
Posted Thursday, August 29, 2013 8:33 AM



Group: General Forum Members
Last Login: Saturday, February 27, 2016 10:42 AM
Points: 15, Visits: 44
Hi There,

I have two MSSQL Express 2012 databases each on separate machines (one for live LAN Data and the other for external IP access by a website for security reasons)

I've read that SQL Express 2012 can only use replication as a subscriber and since the client does not have the resources (or inclination) to purchase a full standard license simply for Replication, I thought of using an SMO enabled windows service to periodically transfer changed data from one Express DB to the other...

My question is two fold:

1) Is this the best way to do this (bar purchase of a full SQL license)?

2) What crucial considerations are there and what approach would be most suited? (I'm assuming RMO would not work between 2 Express versions)
I was thinking along the lines of either making a backup and restoring it periodically or copying entire tables periodically or should I rather compare tables and add new records individually as they get added? (I have a timestamp on records indicating creation and last edit)

Since I've never approached this before, your invaluable expertise would be very much appreciated

Kind Regards,
Post #1489752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse