|
Version 2.4.0.1425
|
|
|

|
Full support of CamelBackedCasing in Table Names - Keys and Columns to better reflect structures.
|

|
Port to SQL now has OPTIONS (with explanation text) to better allow you to select the "step" to perform
|

|
Port to SQL - new option to re create all SQL Tables
|

|
Port to SQL - new
demo application to DEPLOY using the "INI" file technique (change the
INI values for each end-users and NOT the code)
|

|
Port to SQL - Save your settings - restore settings to/from INI files
|

|
Port to SQL - NEW button to allow you to CLEAR all internal FLAGS
|

|
Port to SQL - TWO new TOKENS DCT in Column LEVEL option : DMCSetNULL and DMCSetNotNULL
|

|
Port to SQL - support the possibility to use the Description from DCT to be used in SQL script as a COMMENT
|

|
Port to SQL - Exporting your Project now backs up any previous files
|

|
Port to SQL - support for FRB and taboga barcode template in TXA parsing
|

|
Support to COLOR a profile with any Mapping Option in Orange (extended to all 'normal' options)
|

|
STOP message if you
are trying to connect to a SQL 2008 Server with the 2005 driver "SQL
Driver" in Viewer Data Transfers and Port to SQL
|

|
Support for SQLAnywhere "server" typed ODBC connections with TCPIP additional setting
|

|
Support code during SQL Table clones - readings and DB backup to accept a table Name with a numeric as first character
|

|
Support for CHARSETS in XML exports
|

|
NEW display information string during Data Transfers to inform you of Records processed / Records to process
|

|
NEW setting to allow users to define the GROUPING value they want for formatting figures
|

|
NEW button in Settings (global) to RESET all DMC settings to Factory defaults
|

|
NEW button in Port to SQL to RESET all sql settings to factory defaults
|

|
Setting to read in SQL environment "Tables" or "Views" or "Tables and Views"
|

|
Setting to define if Clones and DCT creations would be "Uppercased" "Lowercased" "CamelBackCased"
|

|
Data Transfer - End of a Batch Processing (except when in silent mode) display the LOG file generated
|

|
Port to SQL -
during selection of destination DB - a filter the list to display ONLY
the connections corresponding to the selected SQL TYPE in previous
screen
|

|
Data Transfers -
method in internal SQL class to get from the server the DateTime FORMAT
used so as to be able to transfer and format accordingly
|

|
SQL Reserved words come in TWO levels to allow you to tweak as per YOUR needs (move between levels is allowed)
|

|
NEW 'use all sql reserved words' setting in Port to SQL - dct screen - and in settings sql tab
|

|
All main tasks are encapsulated in a "long job" animated GIF display without showing the background screen
|

|
Support during the SQL clone and DB backup to REORDER the sql columns (blobs mainly) exactly as they are in SOURCE side
|

|
Support during an SQL DB backup task to use the original BIT type of data when applicable
|

|
Long Task options - define thresholds above which DMC will process the current task minimized
|

|
Clone to SQL - IF the TableName or the SchemaName is an SQL reserved word then DMC will QUOTE all
|

|
Support in MsSQL for schema names which are SQL Keywords - example on a schema called 'tran'
|

|
Full support for 'illegal' schema names throughout
|

|
Data Transfers -
FUNCTION to allow you to define a FORMAT string which can be manually
defined ie @P###-####-###P (or anything you want)
|

|
Data Transfers - OPTIONS in Functions : STORE function result and CONCAT all previously STORED results
|

|
Data Transfers -
OPTION : when you use a multiple column multiple function, you can STORE
this end result to use it as an External table lookup VALUE
|

|
Profiles - a NEW column called NOTES to allow the user to add comments
|

|
Data Transfers - code to protect
the user from adding an external table lookup AFTER other functions if
the STORED value of previous functions is NOT checked
|

|
Data Transfers - code to protect
the user from adding an external table lookup AFTER other functions when
the last function is not STORED
|

|
Clone DB or FOLDER - added SQL "quotes" to allow all types of names to "pass" and for CamelBackCasing
|

|
Clone a DB or a FOLDER - added a 'drop table' script to make your clones easier (no use deleting the existing tables)
|

|
Support for case sensitivity in MsSQL servers
|

|
Port to SQL - when an SQL ERROR is
received by the server STORE this error and ADD it in the "include file"
at the bottom to allow you to see an error exists
|

|
Data Transfers - External
"Replacement groups" Search & Replace the possibility to use
<SP> (for a space) *several* times in *either* Search and/or
Replace values
|

|
Data Transfers - "store" column values in display Q's even when a condition is NOT met.
|

|
Settings - Define the SIZE of the MEMO columns to use when CLONING from an ACCESS table to TPS - DAT
|

|
Port to SQL - NEW tokens in DCT for
procedures to not be changed : DMCSkip and DMCNoRename and
DMCSetIdentity and DMCSkipIdentity and DMCSetGUID
|

|
Port to SQL : setting to define Table Name and Owner strings directly in DCT and not in INCLUDE file
|

|
Port to SQL : all settings can be accessed from "main" settings module
|

|
Port to SQL : Setting to define if KEYS will be case sensitive or not
|

|
Port to SQL : all necessary files are copied for you in YOUR "destination" folder
|

|
Port to SQL - Exporting the project
: if any previous export was done those are archived and all necessary
tables extracted from DMC folders and copied to YOUR destination folder
|

|
Transfer Data with BLOBS : setting
to define TWO thresholds to trigger switching from the (fast) IMDD temp
table to a (slower) TPS one - Nb. Blobs and Nb. Records
|

|
Transfer Data - NEW function(s) to De Punctuate a STRING - Replace and Compact a STRING
|

|
Port to SQL - NEW button "proceed" to avoid stepping through each "advanced" tabs
|

|
Transfer Data - mapping CONDITIONS a
NEW option checkbox (visible ONLY IF a SORT ORDER is defined in
mappings) to tell DMC that this Condition is to be used as BREAK when
NOT MET
|

|
Transfer Data - IF the Number of
records is BIGGER than the setting THEN a popup Message warns you that
the Transferred data TAB will not be displayed (speed up processing)
|

|
Port to SQL - Toggle display on KEYS with autoinc in Normalized DCT display screen
|

|
Navigation Panel changes to allow direct access to tasks
|

|
When Editing a profile, after you close the main window you will be brought back to the Profiles module
|

|
All DCT and TXA parsing's are speeded up
|

|
Port to SQL - code to take you directly to the DESTINATION folder when asking for a TXA parsing to select the TXA(s)
|

|
Port to SQL - support in a DMCSkip procedure to still rename any Procedure CALLS
|

|
Changed DCT and code when DELETING a Project so as to speed up the task
|

|
Corrected code on ExternalColumn Names when they are camelbacked and quoted so as to removed these quotes from DCTX and TXD
|

|
Changed code in reading access
tables so as to DISPLAY a structure WITH BLOBS but to still use in
Viewer or data transfers as source and dest a STRING
|

|
Changed code so as not to display in Port to SQL (Regenerate TXD option) the Select TXA button
|

|
Support for Novegian characters
|

|
Support during a clone to same sql or during an SQL DB backup task to support FLOAT and NVARCHARS
|

|
Support for an MsSQL Identity
column which cannot be updated (sql limitation) - added a new flag
(internal) so as to avoid adding this column in the update script
|

|
SQL environment - select a RADIO to display only Tables or Views or Both - refresh automatically the List
|

|
Code so as to allow you to revert to the MRU list when you close the Viewer (coming from there)
|

|
Data Transfers - code to protect the user from using a Condition on a STRING column and using a NON quoted value
|

|
Port to SQL - support of PROTOTYPES and PARAMETERS when parsing TXA's
|

|
SQL Backup : added a "master" sql
script containing ALL individual scripts to allow a one click restore
(available in create ONLY scripts)
|

|
Clone to ASCII and XML : detect DATE columns in a STRING source and offer to change it to a DATE data type
|

|
"Restore a Profile" -> "Edit a profile" (name change)
|

|
Changed the display and sort order in ODBC connections drop down when creating a new one
|

|
Project & Profiles a new COLOR for you to distinguish when a Profile has Conditions or Functions or Concats
|

|
Port to SQL - depending on the SQL
type of server selected in DCT parsing when you are in the "select
destination server" screen - ONLY related connections are displayed
|

|
CHANGED all DMC distant SQL servers (all will be changed for you automatically) to use a new dedicated server (speed)
|

|
Corrected a bug when a MEMO column was present in VIEWER to allow inserting an RTF data type.
|

|
Corrected a bug where Port to SQL would do nothing DCT parsing if the first table was NOT tagged
|

|
Corrected code so as to clone a
BYTE to an INT when working with MySQL (a TINYINT in MySQL does NOT
allow entering data over 1 char sized)
|

|
Corrected a bug during DB/Folder cloning to SQL on SQL reserved words on Columns and keys and table Names
|

|
Corrected a bug during SQL DB Backup on IDENTITY columns and on component casing
|

|
Corrected a regression bug during
all SQL Clones (including Port to SQL) - all keys would not be cloned
resulting in generated DCTX not being good
|

|
Corrected a bug during data transfer from X to ASCII where the MEMO columns were not transferred
|

|
Corrected a bug when creating a table from TEXT would fail if a Column name contained the word 'file' and was used in a KEY
|

|
Corrected a bug when a profile was edited and when an ASCII Table was used as source (DMC would GPF)
|

|
Corrected a bug when a profile was saved and when External GROUPS were used
|