The DATA COMPARE finishes with errors.
I try to SELECT ALL objects when mapping objects, however not all objects are able to be mapped.
Some objects had X's next to them. I have to manually SELECT these objects.
A sample of errors from log:
DataCompareAndSync; Model; Error; Table Reading error.
8/12/2009 1:49:37 PM; DataCompareAndSync; Model; Error; vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv Exception vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
8/12/2009 1:49:37 PM; DataCompareAndSync; Model; Error; System.Data.SqlClient.SqlException
8/12/2009 1:49:37 PM; DataCompareAndSync; Model; Error; Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
8/12/2009 1:49:37 PM; DataCompareAndSync; Model; Error; Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
8/12/2009 1:49:37 PM; DataCompareAndSync; Model; Error; StackTrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
Error; Table Reading error.
8/12/2009 2:03:30 PM; DataCompareAndSync; Model; Error; vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv Exception vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
8/12/2009 2:03:30 PM; DataCompareAndSync; Model; Error; System.Data.SqlClient.SqlException
8/12/2009 2:03:30 PM; DataCompareAndSync; Model; Error; Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
8/12/2009 2:03:30 PM; DataCompareAndSync; Model; Error; StackTrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for SQL Server.