Data Compare fails with unknown SQL Error

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Data Compare fails with unknown SQL Error

Postby Mathonar » Wed Feb 15, 2012 4:24 pm

I am using SQL Data Compare to synchronize 8 tables between 2 instances of a system.
I have already used SQL Compare to ensure that the schemas are in sync but one of the tables prevents the package from running.

The table has 15 columns to compare and the PK is an identity column which i am using as the Comparison key. If i change the comparison to check just the PK column or the PK + an active flag column (bit) i still get the error.

The error is reported as coming from the source server instance, not the target but all it says is

"The following SQL command caused the error:



"

We have 4 different instances to do comparisons against and all of them exhibit the same behaviour regardless of which combination of source/target instance we use.
Mathonar
 
Posts: 1
Joined: Wed Feb 15, 2012 3:49 pm
Location: Dundee

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests