SQL Compare field mapping incorrect
pmoore
Posts: 10
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.
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
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.
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
