Master Child Database

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


  • 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.

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