Red Gate forums :: View topic - SQL Compare 10 hangs after pressing Deployment Wizard button
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare 10 hangs after pressing Deployment Wizard button

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
atedw



Joined: 24 Apr 2012
Posts: 3

PostPosted: Tue Apr 24, 2012 6:26 pm    Post subject: SQL Compare 10 hangs after pressing Deployment Wizard button Reply with quote

I have tried a number of times to generate a deployment script with SQL Compare 10.1. The issue first occurred when I was using Remote Desktop, so I first thought it was related to that. However, after a number of attempts, saving the project file, starting from within SSMS, uninstalling and reinstalling, I still cannot generate a deployment script.

I can get all the way to where I press the Deployment Wizard button, at which point it hangs (Not Responding). I wonder if there is a dialog box hidden off the screen, because that's sort of how it behaves, like its waiting for input.

Has anyone experienced this behavior?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Thu Apr 26, 2012 8:47 pm    Post subject: Reply with quote

Thank you for your post and sorry that you have encountered a problem.

A support call has been created for you, the call reference number is F0059624.

Can you please enable the SQL Compare GUI logging? Right click the SQL Compare icon in the very top left hand corner of the GUI immediately above the file menu. ->Change the minimum logging level to verbose ->Recreate the error symptoms ->Repeating the right click the SQL Compare icon in the very top left hand corner of the GUI ->Locate the current log file.

Send an e-mail to support@red-gate.com with the above call reference number in the subject field of the e-mail and attach a copy of the log file to the e-mail.

Hopefully the log file will provide some information as to why you are experiencing the reported problem.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
atedw



Joined: 24 Apr 2012
Posts: 3

PostPosted: Sun Apr 29, 2012 5:33 pm    Post subject: Reply with quote

I will do this first thing Monday
Back to top
View user's profile Send private message
atedw



Joined: 24 Apr 2012
Posts: 3

PostPosted: Thu May 17, 2012 5:16 am    Post subject: more info on possible cause... Reply with quote

Sorry it has taken me so long to reply to this...

I tried to enable logging with SQL Compare, but really didn't capture anything of use. However, I believe I may have discovered how this is triggered.

I think I have determined that this problem occurs as a result of a particular chain of events from the interaction of three (3) of the apps in the SQL Toolbelt. We use the latest version of all the apps in the suite of tools. In addition, I am using SQL Server 2008 R2 SP1 on the Windows 7 Enterprise PC at my office, and I have Windows 7 Ultimate on my home PC. We are using SVN at the office for our source control repository.

It all seems to start after I commit some code changes using SQL Source Control during a Windows 7 remote desktop session from my home PC to my office PC (over a VPN of course). This sometimes results in a "corrupted" entry in SVN which manifests after as an error during reading of the SVN entry when making a Migration Script: "Should have two revision for an edit - Expected 2 actual 1." Note: I can actually make a migration script at this point, using the SQL Source Control tool.

However, once there is a "corrupted" entry like that in the SVN tree, any SQL Compares between a DB under source control and one that is not, and that would reference that bad entry from the Source Tree, result in SQL Compare hanging during the generation of the migration script.

I really hope this helps resolve this issue, because as much as I love these tools, this problem has almost rendered SQL Compare unusable for me.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group