Replication between two SQL 2012 Express DBs using SMO

  • 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

Viewing 0 posts

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