How can we help you today? How can we help you today?

Does Data Compare lock the table during data synchronize?

We looking for the tool that allow us to synchronize data between 2 difference tables in production environment.
So, we concern about table lock during data transfer.

Does Data Compare lock the table during data synchronize? (In both side) .
Dino
0

Comments

1 comment

  • Chris Auckland
    SQL Data Compare does not put any locks on tables during an update, any locks that are applied are done so by SQL Server.

    You can view the migration script before you run it so that you can see exactly what SQL Data Compare plans to run on the server.

    I hope this is helpful.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.