How Does The Migation System Use Indexes?

[johng]

When using migration system to update existing records, if primary key is not defined as an import field but there are two other indexes that are matched to incoming fields, which index does the system use to find the match?

Example: Primary key is recordID

Other indexes: bustypeID and customerID

recordID (Primary) is not matched to an incoming field (auto-increment)

bustypeID is not unique and is matched to an incoming field

customer ID is unique and is matched to an incoming field

(Does the system use the first matched unique ID?)

[peterlaursen]

We need more precise information!

The mapping 'proposed' by the wizard (including indexes, defaults etc) is as the ODBC layer on the source returns it when queried about it through the ODBC driver. It may even vary with differenct ODBC driver versions 🙁

We will need

1) Exact description of Source versions and ODBC driver versions

2) A 'create statement for the table' in some unambigious form (SQL, graphics)

3) A jobfile as the Wizard generates it by default and how you would have expected it to be!

Please keep the test case as simple as possible!

Is the Primary Key and the Key that auto-increments the same on the source server or is it two diffrent KEYs ? (some systems allow for that)?

You can create a ticket and attach data here if you do not wnat to expose it public.

[Author]

Posts