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 :-)