Activity overview
Latest activity by Matthieu
Brian Donahue wrote:
Hello Matthieu,
Not knowing the specific cause of the error, it's hard to say. I do not think there is a lot we can do to work around broken network connections in most cases. The solution would be to fix the network. The only thing we have an influence over is the command timeout, which for Data Compare, is ten minutes.
do you have retry logic after the operation has failed? / comments
Brian Donahue wrote:
Hello Matthieu,
Not knowing the specific cause of the error, it's hard to say. I do not think there is a lot we can do to work around broken network connections in most case...
resilience to network error
I have 2 fairly big databases (17 GB) to compare over the network. Since the network here gets hiccups once in a while I usually get a network error and the tool stops before finishing. Is there a ...
Thanks for the update. / comments
Thanks for the update.
Thanks for the update! / comments
Thanks for the update!
rphillips99 wrote:
Any resolution on this. I'm having the same issue. I haven't tried it with DBO yet.
Waiting on Jonathan. He was on vacation last week. / comments
rphillips99 wrote:
Any resolution on this. I'm having the same issue. I haven't tried it with DBO yet.
Waiting on Jonathan. He was on vacation last week.
eddie davis wrote:
Hi Matthieu
Thank you for your post.
I am unaware of any performance issues of which you describe in your post.
Are the database schema's identical between the 2000 database and the 2005 database?
How are you connecting to each server, is one of them remote server located elsewhere or are both located within your LAN?
Just to confirm, this degradation in performance you found is during the comparison phase?
Many Thanks
Eddie
This is happening during the comparison and everything is identical (same backup restored in both) What I found on the net is that there are steps you need to take post upgrade to 2005 to ensure good performance such as gathering new stats and rebuilding indexes. / comments
eddie davis wrote:
Hi Matthieu
Thank you for your post.
I am unaware of any performance issues of which you describe in your post.
Are the database schema's identical between the 2000 database a...
Performance comparison 2000 vs 2005
Hi,
I'm using SQL Data compare to compare a 2000 vs a 2005 database with image columns. 1 of the tables as 2-3 millions records with 1 image column. I wonder if people have noticed differences in t...
Jonathan Watts wrote:
Matthieu,
I should have just replied to your email.
Regards,
Jonahan
Thanks I got it. I was sick 4 days last week. let me know of the next steps. / comments
Jonathan Watts wrote:
Matthieu,
I should have just replied to your email.
Regards,
Jonahan
Thanks I got it. I was sick 4 days last week. let me know of the next steps.
Hi Jonathan,
I sent the trace as you requested. Can you confirm you got the email.
Thanks / comments
Hi Jonathan,
I sent the trace as you requested. Can you confirm you got the email.
Thanks
I created a snapshot of the database with SQL Compare. When I try to use the snapshot I can't specify a username so the problem does not appear.
At this time the DBA is restoring a more recent backup of our database (which we need to do to compare against) I'll let you know if the problem is still around with that newer backup. / comments
I created a snapshot of the database with SQL Compare. When I try to use the snapshot I can't specify a username so the problem does not appear.
At this time the DBA is restoring a more recent back...