Issues Synchronizing to a scripts folder

Compares and synchronizes SQL database content.

Issues Synchronizing to a scripts folder

Postby muaddba » Fri Feb 10, 2012 11:16 pm

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.
muaddba
 
Posts: 12
Joined: Fri Feb 10, 2012 11:12 pm

Postby andy.campbell.smith » Mon Feb 13, 2012 1:55 pm

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?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby muaddba » Mon Feb 13, 2012 3:47 pm

Thanks, forcing binary collation did the trick.
muaddba
 
Posts: 12
Joined: Fri Feb 10, 2012 11:12 pm

Postby andy.campbell.smith » Mon Feb 13, 2012 4:04 pm

Great, glad to hear it!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests