Need to speed up Compares and Deployments

SQL_ME_RICH

I have 2 databases. One has 4 views that produce a result set that I need to compare/sync with another database that holds the result sets in tables.

The only difference in the result sets is that the tables have a lead column (called ID) that is used for uniqueness (Primary Key and Clustered Index).

The problems I am having are everything from speed of the compare and deployments to not being able to deploy at all with claims being made in the form of warnings say nothing can be updated in the table.

The servers are VM's. They are located here in our data center on the same network and backbone (only 1gb but better than a WAN link).

I need to get some ideas on how to optimize things, so if I need to give a call for support - I can definitely elaborate more, but I am in the 14 day trial period, and really need to come up with some solutions.

Please advise...

SQL_ME_RICH

P.S. The result sets of the 4 views and stored space in the 4 tables constitutes about 20 million rows and about 20gb of storage.

Evan Moss

Hello,

Thanks for your post.

This article on performance in SQL Data Compare details the variables to keep in mind and some strategies for optimization: http://documentation.red-gate.com/displ ... ta+Compare

Hope that helps.

Regards,
Evan