Navigation:  Port to SQL > Step ONE (Dictionary parsing) > Select Settings Level

This STEP is to allow you selecting the LEVEL of settings you want to use.

 

There's more help online too. DMC Online Help

 

The SQL normalization settings and Dictionary Cleaning Options are available as either :

 

  1. Advanced (define ALL settings individually - recommended AFTER trying out DEFAULT levels)

  2. Predefined with GUID (add a GUID Column and a Primary Key using this NEW Column to tables with NO primary key)

  3. Predefined with Identity (add an IDENTITY Column and a Primary Key using this NEW Column to tables with NO primary key)

  4. Predefined Minimal (do NOT add any Column or Key - do NOT rename KEYS etc ...)

 

(details of these settings are all available on this comparison page)

 

We recommend using the predefined "with GUID" or "with IDENTITY" levels to start with.

 

Select the Casing you would like to apply : lowercase - UPPERCASE or CamelBackCasing (as is with NO changes)

 

Select the TYPE of SQL server you will be working with (used also with DMC tokens)

 

(ie FireBird requires UPPERCASING and we recommend lowercase for PostGre SQL)

 

 

---