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

Predefined DEFAULT level using GUID Columns

 

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

 

 

 

ADD a GUID Column to tables with NO primary key

 

ADD a PRIMARY Key on this New Column (and change any eventual existing Primary Key to a Unique Key)

 

ADD a PREFIX to all your Keys (name unicity) : PKey_xxx (on PRIMARY) UKey_xxx (on UNIQUE) and NKey_xxx (on OTHERS)

 

ADD a PREFIX to the Table NAME and Table PREFIX (name unicity) : "TableName_sql" and "sql_pre"

 

ADD a DCT VARIABLE on Table Full PATH Name and OWNER : "dmc:sql_TableName" and "dmc:sql_owner"

 

ADD a PREFIX to all Procedure NAMES : "BrowseCustomersSql"

 

DETECT Date and Time Columns : create a STRING and GROUP (OVER the String) and DATE and TIME Columns

 

DETECT and GROUP Date and Time individual Columns (ie : "OrderedDate" and "OrderedTime") in a single DateTime

 

All DCT and SQL scripts will use lowercase

 

ADD the TRN attribute to all window controls

 

CHANGE all STRING Columns to CSTRING Columns (if the size is bigger than 1)

 

REPLACE all DECIMAL(12) OFFSET with a RIGHT(2) OFFSET

 

 

 

This is just an Information STEP displaying a resume of the settings which will be used

---