Lockup when comparing certain tables
mcsolas
Posts: 4
I have the data compare successfully comparing all types of tables in my database. However, when I try and compare certain ones, it just wont work. They are, structurally speaking, very similar. I cannot figure out what is stopping it.
I changed the problematic tables from Non-Clustered indexes to Clustered, then tried again. When I changed that, it stops 'freezing' when starting the comparison. Now it gets to 1% or 3% and stops. The table in question only has 200 rows..
Here is the error I get after waiting for Data Compare to 'unlock' .. takes about 1-2 minutes before this shows up:
SQL Data Compare
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
I changed the problematic tables from Non-Clustered indexes to Clustered, then tried again. When I changed that, it stops 'freezing' when starting the comparison. Now it gets to 1% or 3% and stops. The table in question only has 200 rows..
Here is the error I get after waiting for Data Compare to 'unlock' .. takes about 1-2 minutes before this shows up:
SQL Data Compare
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
This discussion has been closed.
Comments
I'm not sure about this, but it sounds like some sort of DNS problem. If you connect to the server by IP address, does the problem go away?