SQLCompare Aborting

Pete1

When you click the Compare Now button, the first step is Registering Databases.

I get the message :-
XXXX.YYYY-Reading object text
(I have substituted XXXX and YYYY for my names. The word "text" is hard to read.)

Down the bottom of the dialog :-
Index was outside the bounds of the array

When I run the compare with the two databases switched around, the compare seems to run successfully until it reaches the database that has a problem - then I get the same error as above.

Is there a problem with my first database? What can I tinker with to make this work?

Michelle T

It sounds like the problem some people have found with the new object decryption functionality. Try turning off the option 'Decrypt encrypted objects on 2005 and 2008 databases' and see if that fixes the problem.

If that does turn out to be your problem, email support@red-gate.com and they'll keep you up to date with the fix progress for this bug.

Pete1

Thanks for that tip.
When I turned off that option the data compare worked.