| Author |
Message |
tdennis
Joined: 02 Aug 2011
Posts: 7
|
 Posted: Mon Mar 26, 2012 10:36 pm Post subject: Data Compare hangs retrieving schema |
 |
|
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 |
|
 |
eddie davis
Joined: 14 Jun 2006
Posts: 804
Location: Red Gate Software
|
| Posted: Tue Mar 27, 2012 12:13 pm Post subject: |
|
|
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 |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 804
Location: Red Gate Software
|
| Posted: Wed Mar 28, 2012 3:24 pm Post subject: |
|
|
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 |
|
|
tdennis
Joined: 02 Aug 2011
Posts: 7
|
| Posted: Thu May 31, 2012 1:14 am Post subject: |
|
|
This issue is resolved in SQLDataCompare_10.2.0.315.exe
Thank you!!
Traci |
|
| Back to top |
|
|
|
|
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
