Red Gate forums :: View topic - Script file does not resolve difference when ran
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Script file does not resolve difference when ran

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQLAdminCJ



Joined: 28 Dec 2011
Posts: 10

PostPosted: Fri May 18, 2012 11:20 pm    Post subject: Script file does not resolve difference when ran Reply with quote

Hey all,

I am using SQL Data Compare SDK to attempt to synchronize 2 databases. In one table, there is a row where an nvarchar field is off by one carriage return. So, for example, if the field in one database is:

"This is a test field.[CRLF]
"

The field in the other database is:

"This is a test field.[CRLF]
[CRLF]
"

The [CRLF] is a stand-in for the formatting characters \r\n.

When I run the utility I've written, it generates a query to make the shorter field (i.e. the one with one CRLF) to be like the longer field. This generates and I run it on the intended database, but then when I run the utility again, the row is still shorter by one CRLF. This is frustrating. Does anyone know how I can go about addressing this? I would appreciate any help that anyone can give.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon May 21, 2012 4:24 pm    Post subject: Reply with quote

If you are using the SDK to create the migration script, the best suggestion I have is that you are setting the comparison option to trim trailing spaces. You may want to check to see what EngineDataCompareOptions you are using throughout the program.
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