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.)