Settings Comparison Table |
  
|
Settings Comparison Table |
|
GUID |
IDENTITY |
MINIMAL |
ADVANCED |
|
| Dictionary SQL Normalization Options | ||||
| ADD a GUID Column in EACH Table |  |
|
||
| ADD an IDENTITY Column in EACH Table | |
|
||
| DEFINE the NAME to use for this NEW Column | |
|||
| DEFINE if the GUID or IDENTITY will be set as SERVER SIDE Defaults | |
|||
| ADD a NEW PRIMARY KEY on this added Column | |
|
|
|
| CHANGE any existing PRIMARY KEY to a UNIQUE KEY | |
|
|
|
| RENAME all the KEYS (PREFIXING them with "PKey_" - "UKey_" or "NKey_") | |
|
|
|
| DEFINE each TYPE of KEY PREFIX to use (5 chars. max) | |
|||
| DEFINE to use a PREFIX or SUFFIX for EACH TYPE of KEY | |
|||
| DEFINE the SEPARATOR to use (1 char. max) | |
|||
| ADD a PREFIX on EACH Table NAME "sql_" | |
|
|
|
| DEFINE the PREFIX applied to Table NAMES | |
|||
| ADD a PREFIX on EACH Table PREFIX "sql_" | |
|
|
|
| DEFINE the PREFIX applied to Table PREFIXES | |
|||
| ADD a DCT Variable on EACH Table "Full Path" "sql_" | |
|
|
|
| DEFINE the PREFIX applied to Table "Full Path" | |
|||
| ADD a DCT Variable as OWNER "sql_owner" | |
|
|
|
| DEFINE the DCT Variable as OWNER | |
|||
| DETECT DATE typed (LONG) Columns and change for a DATE or DATETIME one | |
|
|
|
| DETECT TIME typed (LONG) Columns and change for a TIME or DATETIME one | |
|
|
|
| DETECT "pairs" of DATE & TIME Columns - GROUP them in ONE DATETIME one | |
|
|
|
| DEFINE the "generic" DATE & TIME "portions of NAME" used in your Dictionary | |
|||
| DEFINE the SQL Reserved Word PREFIX to use "sql" | |
|||
| DEFINE a MASTER SEPARATOR to use "_" | |
|||
| lowercase the generated Dictionary Table - Key & Column NAMES | |
|
|
|
| lowercase the SQL Table NAMES | |
|
|
|
| DUMP to Hard Drive all extracted infos (can be time consuming) | |
|||
| PORT all RELATIONS used to SQL (NOT changeable even in Advanced) | |
|
|
|
| PORT all ALIASES used to SQL Dictionary | |
|
|
|
| PORT all KEYS to SQL | |
|||
| PORT ONLY PRIMARY and UNIQUE KEYS to SQL (others are ONLY in DCT) | |
|
|
|
| Dictionary CLEANING Options | ||||
| RETAIN all GUID and IDENT used (NOT changeable even in Advanced) | |
|
|
|
| RENAME all Procedures (NOT changeable even in Advanced) "sql" | |
|
|
|
| DEFINE the PREFIX or SUFFIX to use in Procedure renamings | |
|||
| REPLACE ALL DECIMAL(12) Justification with RIGHT(2) | |
|
|
|
| DEFINE the Justification replacement TYPE and SIZE | |
|||
| STANDARDIZE ALL DATE Formats to "D017" | |
|
|
|
| DEFINE DATE Formating to use | |
|||
| REPLACE TYPING MODE with 'none' | |
|
|
|
| DEFINE the TYPING MODE to use | |
|||
| CHANGE BIG MEMO Columns (over 8000) to CSTRING(8000) | |
|
|
|
| ADD a TRN Attribute to ALL Window Controls | |
|
|
|
| CHECK for Leading and Trailing PICTURES and MATCH them "@Pxxxxxp" | |
|
|
|
| REPLACE ALL String Columns to Cstring Columns (if BIGGER than 1) | |
|
|
|
| DEFINE the LIMIT SIZE to use for String to CString Replacements | |
|||
| REPLACE all String Columns storing a DATE to a DATE or a DATETIME | |
|
|
|
| DEFINE as DCT SIDE all RELATIONS "cascade" and "delete" | |
|
|