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
matt
0

Comments

1 comment

  • Daniel Handley
    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
    0

Add comment

Please sign in to leave a comment.