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

 

Click on the "Proceed with task" button to define the Level of SQL Normalizations to apply :

 

NOTE : You can also edit all these settings from the Settings item (SQL TAB) on the Files  Menu.

 

 

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

 

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

 

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

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

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

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

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

 

IMPORTANT : You need to select #1 - #2 or #3 BEFORE selecting the "Advanced" level to as to "define" the base level on which to apply the "Advanced"!

 

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)

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

 

Define to use or not External Names in your Dictionary

NOTE : If you select to use External Names, please be reminded that in CODE you will need to remember TWO SETS of column or key names - clarion DCT for Clarion code and SQL (external names) for any SQL code!

 

Define the Destination Folder for OUTPUT Files

 

IMPORTANT : (all generated files will be COPIED to this folder for you to WORK in Clarion from these files)

 

Click on the "Next" button to see a "sum up" of what will be performed for you

 

Click on the "Proceed" button to start parsing your DCTX

 

NOTE : You can SAVE and RESTORE all these settings

---