Comments
Sort by recent activity
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...
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...
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.
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
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.
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...
This happens only in a shared environment where I don't have sysadmin. I tried to reproduce on my desktop with no luck. I'll see what I can do but it might not be possible to use either option.
Thanks / comments
This happens only in a shared environment where I don't have sysadmin. I tried to reproduce on my desktop with no luck. I'll see what I can do but it might not be possible to use either option.
Thanks
5.2.0.32 / comments
5.2.0.32