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

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


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 30, 2013 2:39 AM
Points: 12, Visits: 38
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 vb.net 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,
Riaan
Post #1489752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse