Red Gate forums :: View topic - Data Compare hangs retrieving schema
Return to www.red-gate.com RSS Feed Available

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

Data Compare hangs retrieving schema

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



Joined: 02 Aug 2011
Posts: 7

PostPosted: Mon Mar 26, 2012 10:36 pm    Post subject: Data Compare hangs retrieving schema Reply with quote

Data Compare 10.0.1.119 gets stuck for 30 seconds on each database.

1. Tables & Views : Retrieving schema, Registering databases 83%
2. Compare: Reading DDL triggers 41% and 91%
(one table selected, primary Key of one int column selected, with a where clause for one row, 211 columns selected)

Machine is 64-bit Windows Server 2008 SP1.
One database is local, SQL Server 10.0.4000, 64-bit Developer edition
One is remote, SQL Server 10.0.4064, 32-bit Standard edition
Tried starting a rebooting and starting a new project, still has same problem. Version 9 did not have any trouble.

Running Data Compare 10.0.1.119 from Windows XP SP3 32-bit with the same database and table selection gets stuck for 10-15 seconds at each of the same points.

The lags occur with different servers and databases, but the lag times are different.

Thank you
Traci
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Tue Mar 27, 2012 12:13 pm    Post subject: Reply with quote

Hi Traci

Thank you for your post into the forum.

I am not aware of any changes between version's 9 and 10 that would cause SQL Data Compare to pause or stall whilst reading DDL Triggers.

A Support colleague has compared the source code in V9 and V10 and there have been no changes to the code that reads in the DDL Triggers.

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

Can you please turn on the SQL Data Compare Logging and send to us the log file? To turn on the logging, click on the SQL Data Compare icon immediately above the File menu. Change the minimum logging level to verbose if not already set. Run the comparison, when the results are displayed, obtain the log file and send an e-mail to support@red-gate.com with the above call reference number in the subject field of the e-mail with a copy of the log file attached?

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
eddie davis



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

PostPosted: Wed Mar 28, 2012 3:24 pm    Post subject: Reply with quote

Hi Traci

Thank you for your patience whilst I investigated your issue.

In my testing, the comparison pauses during the registration phase when reading the DDL Triggers of each database. The pause was for approximately 6 to 7 seconds.

I have submitted a bug report for the SQL Data Compare Development Team to consider. The Bug Report reference is SDC-1341. Sadly if you wish to use V10.0.1.119 of SQL Data Compare there is no workaround the comparison will take longer to complete compared to using V9.1.*.

Hopefully the Development Team will generate a fix for this issue in a future version of SQL Data Compare.

Thank you for bring this issue to our attention.

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
tdennis



Joined: 02 Aug 2011
Posts: 7

PostPosted: Thu May 31, 2012 1:14 am    Post subject: Reply with quote

This issue is resolved in SQLDataCompare_10.2.0.315.exe

Thank you!!
Traci
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