Red Gate forums :: View topic - Data Compare fails with unknown SQL Error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Data Compare fails with unknown SQL Error

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Mathonar



Joined: 15 Feb 2012
Posts: 1
Location: Dundee

PostPosted: Wed Feb 15, 2012 4:24 pm    Post subject: Data Compare fails with unknown SQL Error Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group