Hanging at "Calculating dependencies"

JoeSack

Hello,

Using SQL Compare 11.1.3.30 to compare two SQL Server database (2008 R2 instances).

Running a comparison works fine, but selecting an object to sync, clicking "Deployment Wizard", selecting "Deploy using SQL Compare" and clicking Next brings up the "Calculating dependencies" dialog box. The status remains at 0% indefinitely (or at least several minutes with no progress). The sub-title in the dialog box is "Calculating work to do" - but after a few minutes hitting Cancel doesn't work and the only option is to kill the task.

The specific databases being compared have worked in the past, but this behavior started recently. Only 258 objects to compare between databases, and even just selecting on single procedure update causes this hang.

Ideas?

Anu D

Thanks for your post.

I have logged a support ticket for you and will email you regarding the issue.

geezman

I am also hanging at "Reading dependencies" when comparing two databases on two separate SQL 2008 R2 servers. Cancelling does not work and I need to kill the task in task manager.

Anu D

Can you email us at support@red-gate.com and we will log a ticket for you?