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

SQL Compare field mapping incorrect

pmoorepmoore Posts: 10
edited January 11, 2017 10:16PM in SQL Data Compare
I have found that SQL compare is mismatching fields.

I've recreated tables with the same names and field names. The target (data warehouse has a few extra fields).

In the comparison window SQL compare is mapping fields with completely different names and data types. See screenshot. A

I have tried with auto mapping both on and off.

it is also skipping fields with identical names and definitions and treating them as a drop/add.
Source: [RT_LEDG_DISC_COMMENT] [varchar] (max) COLLATE Latin1_General_CI_AS NULL CONSTRAINT [DF_RT_LEDG_DISC_COMMENT] DEFAULT (''),
Target: [RT_LEDG_DISC_COMMENT] [varchar] (max) COLLATE Latin1_General_CI_AS NULL CONSTRAINT [DF_RT_LEDG_DISC_COMMENT] DEFAULT (''),

I'm running version: 12.1.0.3760
Sign In or Register to comment.