SQL Compare processes locking up

jsheets

I have now run into this serveral times...

When I select multiple objects to compare maybe 4 or 5. SQL Compare locks up and thus the processes IDs are locked in my sql server. I cannot get into the db after this happens and I have to end task on SQL Compare. Any ideas? This is causing a big issue for me since I have to restart SQL Serve when this happens just to get into the db again.

Brian Donahue

Hello,

SQL Compare accesses the database initially and then stores all of the schema information in memory. Could it be that you are using an older version of SQL Compare? Version 3 and up does not give you the ability to compare a selection of objects; the whole schema must be collected first. Versions 2 and lower, however, gave you the choice to only collect schema information for a selection or objects.

jsheets

thanks for the reply

I am running version 3.2.0.5 We just purchased the application about a month ago. Any other ideas? this is really causing a lot of grief for us.

Thanks,
Jim

Daniel Handley

Hi Jim

Can you clarify whether you are retrieving the data to compare offline, or you have finished the comparison, have selected objects and are synchronising.

Also are you running the tools on the server or from a workstation.

Regards
Dan

kroach

SQL Compare is locking up if we hit Refersh, or just starting the compare. It Reads the first database fine, but on the second comparing database it locks up.. We hit Cancel and it does nothing. As Jim said we have to stop SQL and restart it

Thanks
Ken

jsheets

Also, we are running this from a workstation. Our servers have over 70 databases with similar structure. This problem is not specific to only two databases.

Daniel Handley

Can you run profiler at the same time and record the commands that are being passed that are causing the problem.

Then send this over to support@red-gate.com with information about the server versions, patches and OS.

Thanks
Dan