Issues Synchronizing to a scripts folder

muaddba · February 10, 2012 5:16PM

I am running SQL Data Compare 9 against a folder of scripts and am having an issue. One of my tables has a row that is always showing up as a difference between my two sources, no matter how many times I sync it. It's always the same row, and I can sync it fine with another database, just not a scripts folder.

Can someone assist with troubleshooting? This is part of a problem we're having with SQL Source Control and syncing a static data table to our source control system, however the error seems to be coming from the data compare tool itself, not the sql source control framework.

Andy C S · February 13, 2012 7:55AM

In cases like this, there are a few options that sometimes resolve strange issues where seemingly identical rows are reported as different. Can you try enabling "Trim trailing spaces" and/or "Force binary collation" in the comparison options, and let me know if either of those resolves the issue?

muaddba · February 13, 2012 9:47AM

Thanks, forcing binary collation did the trick.

Andy C S · February 13, 2012 10:04AM

Great, glad to hear it!

Issues Synchronizing to a scripts folder

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk