What are the challenges you face when working across database platforms? Take the survey
Options

Data String Alignment Issue

rsiemrsiem Posts: 3 Bronze 1
edited January 18, 2023 4:35PM in SQL Data Compare
Using SQL Data Compare  Version 14.7.8.21163 Professional. Comparing same table and table structure data between 2 databases (production and test). Except for some of fields with string data the tables are identical. But Data Compare shows one table's field (Only in Left) as left justified (string data nvarchar) and the same field in the test database as right justified (string data nvarchar) - Only in Right. See attached screen shots. First screen shot show Only Left with data in right aligned columns while 2nd screen shot shows Only Right with data in left aligned columns.

How can I get Data Compare to compare the same aligned columns instead of showing incorrect differences?

 

Answers

  • Options
    rsiemrsiem Posts: 3 Bronze 1
    Have tried multiple compares and turning both on and off the Trim trailing white space, Force binary collation, and Treat empty string as NULL project options and defaults with same compare results. 
Sign In or Register to comment.