Does Data Compare lock the table during data synchronize?

DinoDino Posts: 2
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) .

Comments

  • 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
Sign In or Register to comment.