Cancelling a Comparison

alaistair

I am comparing two SQL Server 2000 databases on two different servers, whilst I was comparing I decided to click 'cancel' the program then just hung,

I had to kill it using the task manager,

i'll see if I can replicate it again and get back to you.

Thanks

Al

Bernard Sheppard

I've seen the same thing happen.

richardjm

Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very large tables this could be the 'hang' effect you're both seeing.

Also you're both ok for disk space I assume?

Bernard Sheppard

richardjm wrote:

Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very large tables this could be the 'hang' effect you're both seeing.

Also you're both ok for disk space I assume?

I'm OK for disk space, and the tables are extremely small (< 10k Rows, under 1MB).

richardjm

Have you managed to reproduce this problem consistently or does it just seem to be intermittent?

alaistair

disk space is also fine on mine

richardjm

I'll put it into our bugs database as a thing to watch out for and we'll get some internal tests going to see if we can find out what's going on. If you have a database that is particularly prone to it or a cunning way to get the
problem to show itself that would be wonderful.

Thanks