Script file does not resolve difference when ran
SQLAdminCJ
Posts: 17
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.
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.
Comments