SQLDataCompare - EXCLUDE Column In XML File

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

SQLDataCompare - EXCLUDE Column In XML File

Postby lc6529 » Mon Jun 03, 2013 5:05 pm

So in my last episode, I was setting up a DATACOMPARISON using an XML file.

Table 1 is to be compared to Table 2. Table 1 has jobs run against it which delete data from the table. The comparison of table 1 to table 2 is to only allow rows to be added or modified, NOT deleted.

All is going well until I setup up MERGE replication from Table 2 to go out to separate servers in other countries.

Now when I compare Table 1 to Table 2, I get "Updating columns with the rowguidcol is not allowed"

I mistakenly thought SQLDataCompare ignored rowguid (bad info from a co-worker). Is it possible to EXCLUDE the rowguid setup by Microsoft SQL from my comparison?
lc6529
 
Posts: 20
Joined: Wed Apr 18, 2007 7:32 pm

Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests