Master Child Database

matt@ezds.netmatt@ezds.net Posts: 2
Is it possible to tell SQL Data Compare which db is the master and which is the slave. In other words, I want certain tables to be updated from the "field" to the "home office" but other tables NOT to be updated from the "field". I want the "Home office" to be king

Comments

  • Hi

    When you choose the synchronisation command you can choose to synchronise from A to B, or from B to A. There is no way to enforce this unless you only give you "remote users" select access to the data.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.