Sync process takes too long!!!

eprivotteprivott Posts: 6
edited November 1, 2006 12:43PM in SQL Data Compare Previous Versions
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.