SQL Compare 10 Hung

Ozzie19

I'm 22% through - the mouseover said 15 seconds left. 5 minutes later I press cancel. Computer is hung - databases in unkbown state - what should I do? Great way to start the weekend.
Doug

David Atkinson

I've not heard reports of this issue before.

By default SQL Compare's script runs in a transaction, so if it doesn't complete, it should roll back.

One thing worth trying is to use SQL Compare to generate the SQL script, load this in SSMS and see if executing it here makes a difference.

Let us know how you get on,

David Atkinson
Red Gate

Ozzie19

David,

I let it hang there another 20 minutes then killed it. Everything rolled back - seemed a bit odd - I never seen your tool exhibit that behavior before.

Thanks,
Doug

David Atkinson

I've not heard of this issue before. Very bizarre indeed.