SQL Compare 10 Hung

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Compare 10 Hung

Postby Ozzie19 » Fri Mar 16, 2012 10:46 pm

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
Doug
Ozzie19
 
Posts: 6
Joined: Fri Mar 16, 2012 10:44 pm

Postby David Atkinson » Fri Mar 16, 2012 11:16 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

SQL Compare 10 Hung

Postby Ozzie19 » Mon Mar 19, 2012 6:49 pm

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
Doug
Ozzie19
 
Posts: 6
Joined: Fri Mar 16, 2012 10:44 pm

Postby David Atkinson » Mon Mar 19, 2012 10:03 pm

I've not heard of this issue before. Very bizarre indeed.
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests