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

Sync process takes too long!!!

I have two tables in one database with 175,000 records and it takes 2 hours to update a table. Is there any way in SQL Data Compare to shorten this process? We purchased the product and it's good, but two hours to update a table :( !

Please let me know if you need any additional information.

Thank you.
eprivott
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello Elsie,

    Unfortunately there is little I can suggest. The whole idea is that SQL Data Compare needs to compare all of the selected tables' contents before it can generate a synchronization script, even if the amount of data eventually being synchronized is very small.

    It is possible to cut down the amount of data by specifying a WHERE clause on the table. This can be done in the user-interface version of data compare only, so if you wanted to utilize this for the command-line version, you would need to specify a WHERE clause in the UI version, save the project, and use the /pr argument to Data Compare to load and use this project.

    I hope this helps you.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.