What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare processes locking up

jsheetsjsheets Posts: 4
edited June 3, 2005 12:04PM in SQL Compare Previous Versions
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.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • Options
    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
  • Options
    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
    Daniel Handley
    Red Gate Software Ltd
  • Options
    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
  • Options
    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.
  • Options
    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
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.