Long Delay when Selected Columns in Tables & Views

Recently, I've been experiencing a long delay after modifying the columns to compare for a table. The wait cursor appears for about 30-45 seconds before the "Save" or any other action can be performed. Currently using SQL Data Compare Professional. Any ideas? Maybe the underlying project schema is corrupt?


  • SQL Data Compare attempts to simplify the mappings configuration each time you make a change.  However, the project file can sometimes get bloated after a large enough number of modifications to the mappings configuration, especially if the same project is reused across significantly different database schemas. 

    If this has happened, it might be worth creating a new project file and setting up your columns to compare again.

    If you're curious, you can take a look at the project file in Notepad and see what is going on under the hood, it's just an XML file although it's not particularly human readable.
    Software Developer
    Redgate Software
Sign In or Register to comment.