Softpedia >Windows >Internet >Servers >Database Utils >Data Management Center >  Changelog

Data Management Center Changelog

What's new in Data Management Center 4.1.0 Build 2791

Jan 14, 2015
  • Portable Version : new code to allow better creation - usage!

New in Data Management Center 4.0.4 Build 2763 (Dec 19, 2014)

  • Port to SQL new setting to add a leading ZERO to "flatened" ARRAY column names in DCT
  • Fixed "flatened array names" during TXA parsing (Port to SQL)

New in Data Management Center 4.0.3 Build 2692 (Dec 19, 2014)

  • Clone to SQL (PostGre) : if a PRIMARY Key contains a DESC column - port as ASC (server restriction)
  • Display of DESC keys during Port to SQL in first display resume screen
  • Support to check during cloning to sql sql reserved names so as to always be current
  • Data Transfer task NEW Button in "Auto Inc" TAB to allow starting from "Destination RECORDS plus ONE"
  • VIEWER (Clarion) Structure TAB added the PREFIX on the FILE line
  • VIEWER (Clarion] Structure TAB added the PREFIX on the KEY Column Components lines
  • Port to SQL options - remove sql reserved words possibility of user defined per sql word and no replacement
  • INTERNAL STRUCTURE of Profiles so as to now contain (Port to SQL) the table Prefix extracted from the DCTX (regression) possibility to transfer TO HF Files
  • Support BLOB data transfers when using MsSQL and when an IDENTITY column is present (sql coding)
  • Fixed "link by name" during data transfers

New in Data Management Center 4.0.2 Build 2692 (Oct 7, 2014)

  • Clone to SQL (PostGre) : if a PRIMARY Key contains a DESC column - port as ASC (server restriction)
  • Display of DESC keys during Port to SQL in first display resume screen
  • Support to check during cloning to sql sql reserved names so as to always be current
  • Data Transfer task NEW Button in "Auto Inc" TAB to allow starting from "Destination RECORDS plus ONE"
  • VIEWER (Clarion) Structure TAB added the PREFIX on the FILE line
  • VIEWER (Clarion] Structure TAB added the PREFIX on the KEY Column Components lines
  • Port to SQL options - remove sql reserved words possibility of user defined per sql word and no replacement
  • INTERNAL STRUCTURE of Profiles so as to now contain (Port to SQL) the table Prefix extracted from the DCTX
  • (regression) possibility to transfer TO HF Files
  • Support BLOB data transfers when using MsSQL and when an IDENTITY column is present (sql coding)
  • Fixed "link by name" during data transfers

New in Data Management Center 4.0.2 Build 2624 (Aug 1, 2014)

  • Support for CodeJock version 16.3.1
  • Installer changed to support Windows 8 and 8.1 (DMC could start without being visible)
  • Various reported bugs from version 4.0.1

New in Data Management Center 4.0.1 Build 2523 (Apr 22, 2014)

  • "Compare Data" (2 Tables ANY Formats) multiple compares possible in TABS
  • Compare : Navigate (mouse - keyboard) on "linked records" (parent - child) - Visualize (colors) differences in data
  • Compare : Filter results by "identical" or "differences" or "missing"
  • Compare : Export these results to PreDefined Formats (HTML-CSV-Excel etc..)
  • "Synchronize Data" (2 Tables ANY Formats) and check the process in a New Compare task
  • Navigation Panels : Left (source) and Right (destination) have splitter bars to best fit your preferences
  • Navigation Panels : Left (source) Pane width can be saved and restored to best fit your temp requirements
  • Main Frame TaskBar : Font Size and Height can be changed to best fit your preferences
  • Main Frame TaskBar : Text can be displayed or not to best fit your preferences
  • Main Frame Information Bar : ICONS can be displayed or not to best fit your preferences
  • Main Frame Information Bar : STEPS "lead" you during all Processes to better inform you
  • Main Frame Information Bar : ICONS (arrows) show you where to "do something" Now and Next
  • Main Frame Information Bar : TEXTS tell you WHAT to do Now and Next
  • Multiple (secondary) "Modules" can be opened at the same time in TABS
  • If an opened "Module" requires to be used "alone" all other Menus are disabled
  • You can close "All Modules" or one at a time when several are opened at the same time
  • You can close DMC from the Frame "Red Cross" (if NO task is running)
  • Notification TaskBar ICON : Right click OPTIONS to "Reset to IDE defaults" and to "Close DMC"
  • "Data Transfer (PostGre)" Truncating a table will RESET any existing SEQUENCE to 1
  • "Data Transfer (PostGre)" if a SEQUENCE is found, DMC will RESET it to highest used value at the end of transfer
  • "Data Transfer" NEW mapping option (SQL) to use a NULL instead of a ZERO (int and tinyint data types)
  • "Data Transfer" NEW mapping option (Replace simple) support to use "E" for EMPTY
  • "Port to SQL" : Added support (PostGre) for sequences and DCT related options (server side autoinc)
  • "Port to SQL" : Added support (MsSQL and MySQL) for Identity and DCT related options (server side autoinc)
  • "Port to SQL" : Added support for SCHEMA selection (PostGre - Oracle and MsSQL)
  • "Port to SQL" : Added support to CASE parse TXA to be sure the app will compile fine on some lookups
  • "Port to SQL" : Added support to BIND columns found in code "linked" to their parent INSTANCE
  • "Viewer" : Extract to Hard Drive all Images (special folder) contained in all Binary Blobs (user defined format)
  • Setting "Snap Mouse to Default button" : in Forms and Internal Messages position the cursor on the Default button
  • Display changed Properties during a Clone to DAT Task (column name - column type - column size)
  • Excel EMPTY Sheets are no longer listed
  • FireBird - Keys were not properly ordered
  • FireBird - Columns within a Key were not properly ordered
  • Various reported bugs from version 3

New in Data Management Center 3.2.2 Build 2330 (Oct 11, 2013)

  • Added in the installer the DMC Clarion9 DCT addin
  • Added in BLOB Viewer an 'HEX' TAB to allow you to see the HEX value of your BLOB
  • Added in BLOB Viewer the BYTES size information
  • Added in SQL env .module spillters
  • Added in Data Transfer tab a splitter
  • Added in Previewer and SQL env. resulset GROUP BY feature
  • Viewer - SQL env. when querying a "complete" Table in the Structure TAB : display the SQL Script.
  • Viewer - SQL env. Structure TAB : right-click to toggle Clarion Structure / SQL script
  • Added support to Oracle Tables with spaces in column names
  • Added support to READ and WRITE to Tps or Dat Tables containing DIMMED GROUPS
  • Added support to store in MRU list when you DROP a table in the Frame
  • NEW feature when opening a DAT encrypted Table : LEFT and RIGHT Panel "pwd" OPTION
  • Support to display changed Properties during a Clone to DAT Task (column name - column type - column size)
  • Added 'TXT' as extension when reading an ASCII file
  • Added support to rename during a clone to SQL any illegal '-' contained in an EXCEL Table
  • "Port to SQL" : Added support to add 'send empty instead of NULL' in UK compound keys
  • NEW SETTING to define the top frame toolbar Icon/Font sizes & display TEXT or not : override the default settings.
  • Support when Porting to SQL on "retrograding to c6" a TXD - when you use in DCT a QUEUE with NO PREFIX
  • Changed code when Transferring Data "clarion code" (when there are BLOBS/MEMOS) to speed up the process
  • Corrected code in Data Transfers : DISPLAY in "Transferred Data" TAB properly formatted DATE columns
  • Support during Transfer tasks to NOT allow the user to select the Destination side IF the source side is not done 1st.
  • Changed Data Transfer 'data' tab (source and destination) from lists to report Controls
  • Changed Data Transfers 'transferred data' to a ReportControl (with ICONS to differentiate results)
  • Reviewed the PRE VIEWER code to display column names as they are cased in SQL
  • All windows (metro form look) are now with "joined" smaller Ok and Cancel buttons (lower right)
  • "Email us" module changed port to 25! NOTE : in previous versions please change this manualy to avoid a error
  • Changed code during a Clone to SQL (FireBird) to clone a NON Binary Blob to a BLOB (and no longer a varchar)
  • Added support for a Port to SQL parsing when a COLUMN name contains a colon (c8/c9 bug imports as an OVER col.)
  • Changed code when Transferring Data to better display the progress bar when loading Source data
  • Recoded the Clone to DAT task - now displays the Table Creation Wizard with all done for you
  • Changed code to "Port to SQL" properly ALIAS Keys (not ported tables)
  • Use NEW progress bar when transferring data in Transfer tasks
  • Fixed a bug in the Date and Time calendar class - could pick up a wrong date in some cases
  • Fixed a bug in a Compare Structures tasks.
  • Corrected a bug when Cloning to TPS from Excel and saving a Profile
  • Corrected a bug in "Port to SQL" when the last table ported requires adding a sys_id column
  • Corrected a bug when cloning an MsSQL table to another SQL and applying sql normalization on KEY names
  • Corrected a bug when trying to rebuild keys on several tables (would send the "eval" message restriction)

New in Data Management Center 3.2.1 Build 2247 (Jul 22, 2013)

  • New SQLite full support (View - PreView - Clone - Transfer - Compare)
  • New Visual Query Builder (SQL environment)
  • MULTI cloning Tables from SQLite to SQLite : use the ORIGINAL sql script extracted from Source
  • VIEWER now contains a new EIP calendar "DateTime" Class - a popup calendar with Date AND Time !
  • Global settting : machines with NO Internet or Firewall "pbs" can request and register serials
  • Global setting to define 'use Query Builder'
  • Local (SQL Env.) setting to override 'use Query Builder'.
  • Support for TPS tables containing a PICTURE as SIZE
  • Support for a METRO LOOK Message procedure to replace the inbuilt one
  • FUNCTIONS during Data Tranfers to CALCULATE on MULTIPLE Columns
  • Global setting : CSV/XML Export or Clone STRING (memo) columns (strip out all lf's and eof's and double up quotes)
  • NEW version of DMC install : the Profile parsing is now accelerated to avoid long processings
  • MultiTable Data Transfers - reviewed all this 'chain' (including the "Run profile" option)
  • Support DECIMAL column types NOT to be "seen" differently than they are in all SQL's (sizes could be wrong)
  • Changed code during all (internal procedure used to process Q's to Files) to speed up processing
  • Changed code during all Port to SQL "dumps to HD" (TPS internal files and TXA) to speed up processing
  • New version install when you have "old remote server" connections, you could NOT cancel the "Replace Message ?"
  • Port to SQL "retrograde" option - IDENTS would be wrong
  • Port to SQL and Data Transfers batch transfers when a TPS source Table had a DCT declared hardcoded OWNER
  • Port to SQL and Data Transfers batch transfers when the FIRST Table is empty
  • Working on a TPS as Source with a MEMO and an MsSQL table as Destination with a varchar(max)

New in Data Management Center 3.1.1 Build 2182 (May 17, 2013)

  • New User Interface with FLAT Metro look (Windows 8 and 2012 compatible)
  • Support during SQL Data Transfers [MsSQL, MySQL, PostGre and DB2] to use BULK INSERTS scripts (speed up task)
  • NEW Global SETTING allows you to define if YOU want to use this BULK INSERT feature
  • DMC will create an SQL script on 1,000 Records instead of EACH Record (ONLY for INSERTS) and execute it]
  • IF an SQL error is reported, DMC will AUTOMATICALLY switch back to INDIVIDUAL Inserts (for this "batch" ONLY)]
  • New SETTING to use OR online HELP pages OR downloaded CHM
  • Internal LastChanceHook procedure changed to allow end users NOT to be bothered with EXCEPTION messages.
  • Support for SQLAnywhere 12
  • VIEWER mode : RIGHT-CLICK on the "Main" 'ODBC & SQL Connections' row to Refresh / Rebuild the list
  • NEW Pre Visualize Table on the RIGHT-CLICK in left panel (even on Excel - Access and HF tables)
  • NEW Port to SQL normalization SETTING : "Add to Hot Fields list"
  • Changed code to SPEED up all SQL and TPS - DAT table LOAD times
  • NEW Feature to display in the "Transferred Data" TAB the SQL error returned by the server
  • NEW Feature when Cloning a single Table to be able to use 'apply sql normalization settings'
  • NEW LOG in Port to SQL Tasks : when the user asks for Columns found in CODE to be added to the HOT Fileds List(s)
  • Support when working on an MsSQL table with a varchar(max)
  • When parsing a TXT file to create a new table - better support for SPACES in the FILE and KEY lines
  • Changed code in Runtime Engine to display differently (no as many empty lines as before) the tasks processed
  • Reading a Clarion .DAT Table DMC rebuilds the KEYS when needed BEFORE opening the Table
  • Support in Port to SQL TXA parsing for EMPTY MODULES
  • Support when transferring data to Acess for table names with SPACES
  • PREVIEWER, Port to SQL, Batch Transfers and SQL DB Backup tasks use hand coded CodeJock controls
  • Support for IDENTITY columns in MsSQL when a Table Name is an SQL reserved word (like 'names')
  • Changed code to NOT remove any linked column when adding (after a link) a DateTime function
  • Backup SQL DB task with Non Binary Blobs
  • Port to SQL when TPS Passwords are used and when NO table renaming is asked as setting
  • Transferring Data to SQL and a DATE column exists in DESTINATION side
  • Support to disable the Transfer data button (right click to unlink the last linked column) in a Data Transfer
  • Transferring Data from a VIEW - you could not transfer as the button was hidden
  • Port to SQL when parsing TXA - it would delete all old generated TXA's
  • Port to SQL when no table renaming is asked and dct vars are NOT asked on table names
  • Port to SQL when add ServerSide GUID was asked the DEFAULT value was not in the sql script
  • Port to SQL for CPCS reports and to BIND any columns used in code in REPORTS
  • Port to SQL for users asking a DCTX parsing with NO table renaming and NO Global DCT Var prefix
  • Port to SQL in TXA parsing on Filters
  • Creating an Access ODBC connection (could not select the mdb files)
  • Port to SQL TXA parsing - it could add a NON PORTED table to Table Schematics
  • Clone to Access - if a DOUBLE column was present with a SIZE it would NOT create the table
  • Clone to Access (extra comma at end of KEY script)
  • PREVIEWER when accessing a VIEW with spaces in the Name
  • SQL Env. when accessing a VIEW with spaces in the Name
  • During IBM DB2 KEY queries on the server
  • Creating a Mimer or Pervasive or SQLAnywhere or DB2 ODBC connection
  • Reading in SQL env. several HF Tables - would GPF
  • Port to SQL and Data Transfers batch transfers when a TPS source Table had a DCT declared hardcoded OWNER.
  • Port to SQL and Data Transfers batch transfers when the FIRST Table is empty - would GPF.
  • Working on a TPS as Source with a MEMO and an MsSQL table as Destination with a varchar(max)

New in Data Management Center 3.0.2 Build 2041 (Feb 25, 2013)

  • DMC is now available from a "Web Access" Gateway for Demo or Enterprise level "one-time jobs"
  • "Web Access" Enterprise license with SQL servers [MsSQL - MySQL - PostGre SQL and Firebird] & FTP access
  • NEW licenses for all Non Clarion Users (NO "Port to SQL" task)
  • ONLY the [Clarion] Enterprise and [Clarion] Runtime Engine licenses include the "Port to SQL" task
  • Support in "Port to SQL" for arrayed columns in ALIAS Tables
  • Support during Data Transfers : multiple conditions and the first record does NOT meet the condition
  • SQL Test servers are now deployed on TWO distant servers [US] and [EU] (geo localized from your IP)
  • Menu Files/Settings "Main Options" TAB "Check default ODBC connections" button to use these SQL distant servers
  • Changed screen design in "Port to SQL" task to accept resolutions like 1320x768
  • Corrected a bug when working with Oracle on a DATE Column
  • Corrected a bug during a Backup SQL DB task with Non Binary Blobs
  • Changed code to better support during Port to SQL InitialValues (could be truncated)
  • Corrected a bug in "Port to SQL" on Procedure names (no table renaming and no procedure renaming "case")

New in Data Management Center 3.0.1 Build 1896 (Oct 4, 2012)

  • Windows8 support (this OS is detected and buttons displayed in METRO style)
  • Setting for SQL DateTime display in the format stored in the SQL server or Clarion way
  • VIEWER limitations on ORACLE Tables using CamelBackCasing (NO saving)
  • DATA Transfer limitation (will not continue) when the DESTINATION Table is ORACLE using CamelBackCasing
  • MULTI SELECTION (windows style) SQL or FLAT Tables and DELETE them directly with a rigth click
  • When deleting or adding ODBC connections in the LEFT panel it will automaticaly refresh the RIGHT panel (if opened)
  • New FUNCTION during data transfers : DEFORMAT() +
  • VIEWER (export to CSV) - support to APPEND to an existing CSV file
  • Support to Clone from ASCII to ... (single Table)
  • Support to "remember last clone to folder for FLAT Tables"
  • BUILD all Keys (internal tables) when you close the Project and Profiles module
  • Left navigation panel (right-click) in MsSQL - MySQL and Postgre to CREATE a NEW DataBase
  • Left navigation panel (right-click) in MsSQL - MySQL and Postgre to DROP the DataBase
  • Left navigation panel (right-click) in MsSQL and Postgre to CREATE a NEW Schema
  • VIEWER open MULTIPLE Tables simultaneously
  • Previewer (CtrlW) after selecting a table to access the raw data
  • Support for BIG VARCHARS (Bigger than 2048) to be cloned as MEMOS (TPS limitation of 15 k)
  • Structures are displayed (Viewer) as they are (not only Clarion way)
  • Select MULTIPLE Tables (TPS - DAT) in the Left panel, RIGHT click to rebuild all KEYS on ALL Tables
  • Support for Nested Grouped Arrays in TPS Previewer
  • Display of time taken to perform some tasks in the status bar
  • MENU Folders/User Clones - this will open the folder YOU define as your default CLONE TO folder
  • Support to DELTE in MRU list per selected DRIVER
  • Port to SQL : TXA parsing supports to ADD any COLUMN found in CODE to the HOT FIELDS list
  • Port to SQL : NEW DCT TOKEN used at TABLE level and named DMCNoRenameTableUseFullPath
  • Port to SQL : New setting to use "external names" in DCT
  • Port to SQL : New setting of "External Name casing" (lower-upper-CamelBack)
  • Port to SQL : New DCT TOKEN at COLUMN LEVEL (dynamicaly change the DATA TYPE) "DMCUserDataType"
  • Port to SQL : New DCT TOKEN at COLUMN LEVEL (dynamicaly add a default value) "DMCUserDefault"
  • Port to SQL : find store parse and restore any TRIGGER contained in the TPS DCT
  • Port to SQL : New setting to use NVARCHAR (MsSQL) on all your STRING and CSTRING
  • Support during data clones and transfer for TPS tables with a BINARY MEMO column
  • Support (column "linking") TIME column in sql side (automaticaly check the "use datetime" function)
  • Support in a TPS BINARY MEMO column data transfer to dynamicaly select the type of coding to use (from CONTENT)

New in Data Management Center 3.0.1 Build 1895 (Oct 3, 2012)

  • New Clarion8 IDE addon in DCT editor : open a DCT Table (flat or sql) in DMC Viewer
  • New Clarion8 IDE addon in DCT editor : convert a DCT Flat Table to TPS - DAT - SQL
  • New BUTTON in settings 'DMC Tab' will allow you to manualy add any deleted default ODBC connexion
  • New in settings 'Options Tab' will allow you to store all TPS passwords by default
  • LIMIT the Viewer (on saving changes to HD) when there are several Tables opened at the same time
  • Support when Cloning a TPS encrypted to TPS to use the same PWD in the cloned structure
  • New setting to either display in Information Bar ARROW ico or STEP ico files
  • Support to detect the SIZE of the PageFile and of installed RAM (inform you to change this OS setting)
  • Support during a clone Table task to eliminate a Key on a GROUP
  • MRU List : automaticaly delete any flat table the user has deleted from HD
  • MRU List : export to Runtime Engine format (to allow viewing of SQL tables)
  • Support for Oracle 11g
  • GLOBAL setting (SQL TAB) to allow the user to define the SIZE to use when reading PostGre SQL CITEXT
  • Single or Multiple Table Data Tranfser from the same Task
  • Single or Multiple Table Clones from the same Task
  • Detach a "viewer panel" from the IDE and move it around your screen(s)
  • MULTI Tagging in Profiles (for deletes) Buttons and Keyboard Shortcuts
  • ODBC connections displayed in a Property Grid
  • Windev ODBC driver v14 is added to the installers named as 'HyperFile SQL v14 [DMC]'
  • Changed code when reading an ASCII (TXT or CSV) file so as to SPEED UP readings
  • Corrected code so as to Clone and Transfer data from a MySQL LONGTEXT BLOB to an MsSQL TEXT BLOB
  • Corrected code when data is transferred on the display Q when a DateTime Group to NOT display the STRING(8)
  • Removed from code the Reset all default distant sql server connexions when upgrading DMC
  • Changed the SIZE of the column used to store your licence NAME info (was set to 30 so some had truncated infos)
  • Port to SQL on TXA parsings a NEW case when a SET(Key,Key) is found in code to add a DMC COMMENT
  • Code to prohibit the user from closing DMC from the frame X
  • Changed code so as to display a BLOB in VIEWER as ' ... ' and not the binary data
  • Changed all "side module" windows to always have the same size for the window and the close button position
  • Added more code to "protect" XP clean Installs or Upgrades : message warning the user of a restart of the IDE
  • Changed code in MRU list to display ONLY IF you have saved "favorites"
  • Portable version is now self contained in "molebox" container
  • Run a Profile does NOT close the IDE but processes the task immediately
  • Port to SQL : process tasks without closing the IDE
  • Corrected a BUG when doing a VIEWER Query and when NO records matched - all the records were displayed
  • Corrected a bug when performing an SQL BD backup task if a table was empty
  • Corrected a bug in Port to SQL (date time detections depending on sql server flavours and version 2005/2008/2012)
  • Corrected a bug when reading a MsSQL table with a varchar(7) - was seen as a TIME column
  • Corrected a bug when using a FUNCTION to : + - / * when working on a STRING during Data transfers

New in Data Management Center 3.0.1 Build 1875 (Sep 26, 2012)

  • Newly added feature
  • Changed, reviewed, modified feature or code
  • A reported error or bug was fixed

New in Data Management Center 2.4.3.1539 HOTFIX (Nov 22, 2011)

  • Corrected a bug during UPDATES done in data Transfers on compound Keys
  • Corrected a bug during UPDATES done in data Transfers when the Column Names contains a PREFIX

New in Data Management Center 2.4.3.1539 (Oct 12, 2011)

  • Added TWO new FUNCTIONS during data transfers : parse (n) using a COMMA as separator and a PIPE as separator
  • Added support for Table Names containing ':' in Port to SQL retrograde
  • Added support for a table containing a Q in Port to SQL retrograde
  • Added support for Port to SQL Table Key and Column names containing a ':'
  • Added code in TXA parsing to properly rename columns used in SetFilter(' expressions ' )
  • Added better support for code to change a procedure name when this code is in embed �foreProcessData
  • Added better support in TXA parsing when a local variable was starting with a table name
  • Added support to correct a c6 bug where changing a table prefix in dct editor does not always change the window controls
  • CHANGED behavior during these Parse (n) functions so that if the selected 'n' does NOT EXIST in the column then an EMPTY STRING is sent
  • Changed code to workaround a string parser pb found when an empty cstring '' is seen as having a value of ' ' by the compiler
  • Corrected code so as to display properly transferred data when the destination is a TPS with embedded tableprefix in column names
  • Changed code during TXA parsing which should eliminate more local variables been seen as table names and also speed up the processing
  • Corrected code when linking columns by name (data transfers) to support Access tables with Blobs
  • Changed code so that when doing a concat_before or after during data transferring - the concat string value is used instead of a hard coded space
  • Added support for table named 'event' and 'message' during a Port to SQL
  • Corrected a regression bug on massUpdate (stored queries would not display)
  • Corrected a bug during Port to Sql when working on DAT Tables (mapping profile used a tps extension instead of a dat one)
  • Corrected code to add support for a LIKE(MyColumnName) in a local data declaration during Port to SQL
  • Corrected code when transferring from ASCII as source so as not to SORT the Q on column 1
  • Corrected code when Porting to SQL when a procedure is declared as GLOBAL not to rename it as GLOBALsql
  • Corrected a bug during Runtime Engine using HyperFiles
  • Corrected a bug on Dynamic indexes during Port to SQL to not choke Clarion when importing a TXA
  • Corrected a bug when an SQL Table has a FLOAT to read it as a REAL
  • Corrected a bug in all screens which would end up with a CAPTION
  • Fixed a bug when cloning an Access DB to SQL when there is a MEMO-BLOB
  • Fixed a bug when cloning an Access DB to SQL - sql scripts were not saved to HD (path containing a dot in name ...)
  • Fixed a bug in internal sql class on Access tables with a PK named PRIMARYKEY where DMC would read it as PK_PK_PK_PK_PK_PK_PRIMARYKEY
  • Corrected a bug during MySQL port to sql when grouped date and time columns where present - also touches postgre sql - the cols where not grouped and the time col was dropped
  • Corrected a bug during a table Clone with SQL normalization applied to remove surrounding '[' & ']' from the table name
  • Corrected a bug during Data Transfers on SqlAnywhere where the trunaction would return an errorcode and prohibit the transfer
  • Corrected a bug during SQL cloning on Descending Keys and when a PostGre SQL Table was used on schema "public"

New in Data Management Center 2.4.2.1469 (Aug 16, 2011)

  • Added support for SQLAnywhere schemas so as to allow you to differentiate all Tables and all Views
  • Added a new TOKEN for Port to SQL in CODE add at the END of any code line !DMCSKIPLine and DMC will NOT parse this ONE LINE
  • Added code so as have the system tray icon reflect what is happening during a TXA parsing (dmc being hidden)
  • Added code to protect values within quotes during TXA parsing of a Port to SQL task
  • Added a NEW COLOR definition in the THEMES to allow you to define what COLOR you want your BUTTONS (background) to be
  • Added new feature during Port to SQL : during the first dctx reading phase which displays the tobe sql dct - now you will have a report list of any duplicate KEY names found in your dct
  • Added a NEW Table level option TOKEN - DMCLevel - during a Port to SQL define the ORDER in which the Tables will be treated and mainly the Data Transfer Profiles order (Parent-Child)
  • Added in CSV export a stop or continue message
  • Corrected the BLOB Temp Table in IMDD support to work properly (with a HUGE improvement in time taken to process Tables with Blobs)
  • Added support for a concat detail during data transfers the necessary code to accept a value of to be used as a separator for a SPACE
  • Changed SQL reserved words browse - form to open up a form and not EIP and added a filter on this browse to display - ALL - level 1 or level 2
  • Changed the Port to SQL default project NAME to also reflect the full path name of the DCTX used
  • Removed from "select task" the manage your profiles as that was redundant with the navigation panel link
  • Changed the override defaults on Date and Time detections during a clone to SQL task to display icons showing what will happen
  • Corrected the code used to LOCATE a record in Table Lists (main wizard)
  • Corrected a bug when in Viewer mode and the table contained less than 50 records - the Viewer would report "all records read"
  • Corrected a bug in ODBC driver where a string(2000) in PostGreSQL was seen as a memo (a TEXT in sql language)
  • Corrected a bug in ODBC driver which sees a PostGreSQL ByteA blob as a string
  • Corrected a bug during SQL normalizations on "Next" and "Previous" buttons
  • Corrected a bug in Port to SQL on data type when using MySQL which could break the dctx generated
  • Corrected a bug in CSV export for the progress bar to display properly
  • Corrected a bug in SQL DB Backup edit and restore scripts
  • Corrected a bug during Clone to SQL when a BLOB was not placed at end of table structure in SQL
  • Corrected a bug during Port to SQL on a DCT without any relations - then columns were badly renamed and ended up with empty screens
  • Corrected a bug during Port to SQL on MySQL PRIMARY keys

New in Data Management Center 2.4.1.1433 (Jun 29, 2011)

  • Added code to allow during data transfers a CONDITION on a TIME column to be DYNAMICALY changed reading from an INI file (like for the DATE Dynamic Conditionals)
  • Added code to workaround an SV ODBC driver bug which "sees" an sql2008 TIME column as a STRING(8)
  • Corrected a bug during Port to SQL where DMC would GPF at the beginning of the task
  • Corrected and reviewed all the code during a Clone to task (DAT to DBF mainly) when DMC would not "see" properly the created destination table
  • Corrected a bug during Access Tables reading when a KEY was declared on a MEMO column
  • Corrected a bug during cloning to PostGre SQL - adding quotes around column names xxxxx up everything while reading the table
  • Corrected a bug in VIEWER when saving to file on SQL tables (nothing would be saved)
  • Corrected a bug on any Oracle DB query - DMC would GPF
  • Corrected a bug during Port to SQL on tables containing MEMO columns (these where not ported)
  • Corrected a bug in data transfers if the user clicked on "check mappings" then a GPF would happen
  • Corrected a bug in Port to SQL on DATE and TIME columns (sql2008) when they are used in a KEY
  • Corrected a bug in Port to SQL when a TPS table contains a column with a leading '_'

New in Data Management Center 2.4.0.1425 (Jun 20, 2011)

  • 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 (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

New in Data Management Center 2.3.2.1231 (Dec 9, 2010)

  • Port your Application to SQL added a Wizard like Step by Step to allow you an easier navigation for this feature
  • Port your Application to SQL added the possibility for you to DEPLOY your new SQL Tables to your end users machines (with the Runtime Engine)
  • Port your Application to SQL added support for more c6 to c7 DCT errors (GLOBALS without a DRIVER - OPTION control with several predefined values etc ...)
  • Port to SQL - TXA parsing added many Legacy "cases" and during table Name matching (Create profiles) a NEW display order to make selections easier.
  • Port to SQL - Save your settings to HD and Restore settings from HD
  • Changed code used when Transferring Data to FireBird with BLOBS and on Alias Tables in Port to SQL
  • Added in Settings the possibility to access all SQL Normalization options and to define the CASE to use for DCTX and TXD generation
  • Added in Settings the possibility to display or not at the end of a data transfer the records (save time if not needed)
  • Corrected several bugs in Clone to SQL (Firebird) when a BLOB NON Binary column existed in Table or when a DynIndex is the last key

New in Data Management Center 2.3.1.1205 (Nov 13, 2010)

  • Port your Application to SQL added a Casing setting to retain existing CamelBackCased Names
  • dssg_versions_add_on Port your Application to SQL added a setting to ADD a NEW Column (GUID or Identity) ONLY if NO Primary Key
  • dssg_versions_add_on Port your Application to SQL added when replacing a STRING to Date to extract and use the DCT PICTURE in Data Transfer
  • dssg_versions_change All Tasks performed in DMC are now called from the Procedure TIMER which makes the IDE totaly responsive
  • Clone to CSV added a renaming Destination Table option
  • Corrected a bug in Mysql CLW file generation and in ShellExecute (removed a Wait Flag)

New in Data Management Center 2.3.0.1193 (Nov 1, 2010)

  • Port your Clarion Application to SQL (with full SQL code compliancy and Data Transferring option) Clarion 5.5/6/7 - ABC and legacy support
  • Full Support for MIMER SQL
  • Advanced level Capitalizing during Data Transfers (define always uppercased - always lowercased and direct replacements "cases")
  • During a Clone Table to SQL you have the possibility to apply SQL normalization settings (as per your defined options)
  • When any Task is opened or running the Main Frame Close Application button will popup a message to Close the Task
  • Corrected several bugs in existing code (Identity on SQL Tables - Colons in Column Names etc...)

New in Data Management Center 2.2.0.0 (Jun 29, 2010)

  • Table & Sql DB level STRUCTURE Comparison tasks
  • Compare a Tps-Dat Table to another Tps-dat Table (superfiles and encrypted ones are allowed)
  • Compare a Tps-Dat Table (superfiles and encrypted ones are allowed) to a single or MULTIPLE SQL Tables
  • Compare an SQL table to a single or MULTIPLE SQL table(s) - INTER SCHEMA comparisons is possible
  • Compare an complete SQL DataBase to another SQL DataBase (Tables are "linked" by NAME)
  • All DATE & TIME selections have a VISUAL tip field to allow you to SEE the FORMATED data
  • SQL environment (Ctrl+Q) & Compare Structures (Ctrl+C) MENU & Navigation Panel with keyboard shortcuts for more user friendly IDE
  • Global setting to allow during a CLONE to SQL Task to lowercase all NAMES
  • Global (and popup message) option to allow you to define if an TXD/DCTX Export will be generated in lowercased NAMES
  • During a CLONE DB & Folder task all KEYS are dynamically renamed (if needed) to avoid DUPLICATES
  • Workaround a BUG found in Clarion ODBC driver on reserved words used in KEY NAMES - "PRIMARY" would be read as "KEY_PRIMARY"
  • All Temp tables created by DMC to store Columns HIDE/UNHIDE are now stored in a special DMC temp folder (avoids cluttering your data folders)
  • Corrected a bug in Destination side TPS Multitables encrypted when asking to store the password
  • VIEWER on a MEMO field - now you can also see the content of an RTF - HTML and XML properly displayed
  • SQL Backup task when BLOBS were present
  • Clone Folder with superfiles & during an ACCESS type clone & Export to CSV from Viewer

New in Data Management Center 2.1.0.0 (May 13, 2010)

  • MENU with keyboard shortcuts for more user friendly IDE
  • Global Setting to Hide / Unhide the Left Navigation Bar - Entirely resizable Frame (smaller than 800x600) is supported
  • SQL VIEWS are available as SOURCE and in Viewer with their definition as declared in the sql server (NEW Tab)
  • Create an SQL VIEW from a manual query and Export the Structure to TXD / DCTX
  • In Projects : button to REPAIR all when master key no longer works (seems like conditions - functions are no more available in a profile)
  • Full support for MsSQL SCHEMAS (displayed as dboTableName etc ...)
  • Full support for Excel 2007 /2010 files and illegal characters in column names (spaces and accentuated letters) [also in ASCII Tables]
  • Changed code to reflect sql server error messages during sql manual queries
  • Changed the button (and code) in SQL environment 'SQL Data' Tab to close the TAB (and revert to main one) instead of closing the module.
  • All Temp tables are now IMDD to speed up all tasks and processing
  • Support for Oracle - Postgre SQL and MsSQL SCHEMAS in Cloning task (allows you to clone a Table from SchemaA to SchemaB)
  • Mapping option : Function lookup on external Table to act as FILTER
  • Wizard Create table - Portable version creation - Memo columns transfer - TPS (prefixed tables) during Viewer and Transfers - space in MsSQL Table Names

New in Data Management Center 2.0.0.2 (Apr 15, 2010)

  • Data Transfers : Support for multiple LINKED conditions (IF or ELSIF)
  • Data Transfers : Support for Manual Condition Builder (allows you to build the most complex conditions)
  • Data Transfers : Support for multiple LINKED functions
  • Data Transfers : Support for LINKING a Condition (or a "set" of conditions) to a Function (or a "set" of functions)
  • Data Transfers : Support for a Function of a DEFAULT value - to PARSE (n) th. word & to CONCATENATE within Brackets
  • Data Transfers : Support for DEFORMATING a Date or a Time (enter values in readable format and let DMC work)
  • Data Transfers : Support for DYNAMIC changing the VALUE of a CONDITION (create a condition with Dates as "limits" & change those dynamically from an INI file)
  • Bug in Viewer when a CSV export was done & XML BLOB columns not being exported properly

New in Data Management Center 2.0.0.1 (Mar 22, 2010)

  • Support for postgre sql server side default values (let the server do the work) - when such defaults exist : do not map the column as the server will do it.
  • In system bar the quantity of RAM used by DMC
  • Register your Serial through eMail support (from DMC itself) and phone.
  • In a Manual SQL Query now DMC will add a Primary Key on the 1st Column of the Result Set (import in dictionary to use as a View)
  • DMC is now compiled with the possibility to use MORE than the 2Gb limit (useful on LARGE Tables)
  • Global setting to refresh progress bars each percent (and not each 10% as defined by default) and another one to define Nb Records to read before an INSERT in SQL data Transfers.
  • Support for postgre BLOB columns
  • Changed the DMC Folder Tree Structure to allow all XP machine users to have all DMC table structures updated (FM3 refused to update some when the path was over 100 chars.)

New in Data Management Center 2.0.0.0 (Mar 4, 2010)

  • Backup an entire SQL DataBase in a single Task : create all INSERT CREATE TABLE scripts - ZIP them all (password protection) and Upload the Zip by FTP
  • Clone an entire SQL DataBase (multiple Tables selection) to ANY existing or NEW other SQL DataBase in a single Task.
  • Clone an entire FOLDER containing DAT and or TPS Files (multiple Tables selection) to ANY existing or NEW other SQL DataBase in a single Task.
  • Multiple Tables Data Transfers (SQL DB or a FOLDER containing DAT and or TPS Files) to existing SQL Tables in a Single Task.
  • During Data Transfers to SQL perform EXTERNAL TABLE LOOKUPS to retrieve values and use in the current Table's Selected Column
  • Register Application is entirely new and much easier to use at ANY time on ANY machine - use your DMC site credentials and request your Serial Number
  • New FUNCTIONS and CONDITIONS during Mappings : Conditional SUBSTRING - LEFT and RIGHT & FUNCTIONS on PERCENTAGES ( + - x / )
  • Checking for Illegal Characters during table operations is also performed now on TPS DAT DBF Tables
  • NEW Version of DMC : Runtime Engine for you to use from your application a small footprint engine and distribute to your end-users (SQL Backups - Viewer - Data Transfers etc...)
  • NEW DEMO application installer DMC Runtime Engine with Template TXA & TXD for Clarion 6 - Clarion 7 (it should work on Clarion 5 & 5.5 but not tested)
  • Template used for security and registration (secwin) is deleted and replaced by our own methods

New in Data Management Center 1.7.0.0 (Oct 19, 2009)

  • Create a DataBase in SQL environment module (and a new ODBC connection to match)
  • COMBINE multiple CONDITIONS and FUNCTIONS or CONCATENATIONS or External REPLACEMENT groups in ONE column during Data Transfers
  • When ALL functions used during a Data Transfer task are on the SAME source Column then DMC will apply the 1st result to 2nd function and cascade all
  • NEW Mass Update and QBE layout screens
  • UPDATE a Table - define Values to search for in Destination Table AFTER applying mapping options
  • Data Transfer Tab, added a button to enable the user to VISUALIZE (in another tab) and SCAN "source" & "destination" values AFTER applying mapping options (before transferring data)
  • UPDATE a Table - support to use ANY KEY declared in the Destination Table (mappings are scanned to find related source Columns)
  • STOP process button (main frame toolbar) in Viewer mode
  • SQL server side DEFAULT values are now supported, stored, displayed in mapping options and used when the source record value is empty during Data transfers
  • Main Mapping Tab - NEW screen layout (wizard type)
  • Mapping option window - NEW screen layout (wizard type)
  • Viewer window - NEW screen layout (grouping functions)
  • Clone to SQL - if a table using the same Name exists in DB then DMC will offer the user to drop it BEFORE starting the Cloning task
  • Saving a Profile - the user will be offered to REPLACE the LAST IDENTICAL Profile (if found) or ADD a new one
  • Cloning & Settings - DATE and TIME DETECTION (on LONG columns) during a Cloning Task (user can switch on/off-toggle and define common Column Names used to detect)
  • Cloning to SQL - settings allow user to define a PREFIX to use when the Column Name is a RESERVED word
  • Duplicate an ODBC connection
  • Duplicate a Profile (and all mapping options related)
  • Full compatibility for SQL 2008 server (DATE and TIME column types)
  • Detect Table Name from SQL environment script (user changed it without using the proper button or copy pasted a script)
  • Define the Source ORDER to be used during a Data Transfer (on multiple columns) and set ascending-descending for each
  • Clear all mapping options NEW button in column mapping window
  • Data Transfer - NEW Destination DATE and TIME DEFORMAT dropdown select box when the Destination column is a STRING typed one
  • Mapping options - NEW AutoInc STEP (sequence) entry field
  • UUID Columns in PostgreSQL version 8.4 are detected and used
  • NEW FUNCTIONS added during Data Transfers : FORMAT - DEFORMAT - CLIP -CLIP(LEFT) - EQUAL
  • Transferred Data - records are COLORED to better display between Transferred - Updated and Errors
  • Transferred Data Tab - FILTERS (radios) which can be applied and the SEND TO button follows the filtering (print or save a list of Data manipulation done)
  • External REPLACE "groups" on Search & Replace Tables are STORED WITH their Profile - user can have multiple ones and restore them when restoring the Profile
  • RUN a COMMAND LINE Project or Profile directly from DMC (or copy to CLIPBOARD the command line to use in your application)
  • DATE and TIME DEFORMATING option (dropdown listbox) when the Source column is a STRING
  • ICONS added to ODBC module for better visualizing different connections
  • Data Transfers to ACCESS Tables - support for MEMO column types
  • Changed Projects & Profiles PATH within DMC folders structure for future version 2
  • DAT Tables now allow Password Detection (and storing for second opening)
  • Cloning to SQL use REAL typed Columns in generated script (destination Tables) when the source Table contains some
  • UPDATING a Table (SQL code) to support conversion of DATE column values when used in the selected update KEY
  • DISABLE the Transfer data button when there are NO records in the SOURCE Table
  • DISABLE the "Selected Folder" button during a Clone to TPS till a new folder is selected
  • UPDATE a Table - if the key used as selector has multiple Columns and one of those is NOT mapped then a STOP error message will be sent before starting the process
  • External Replace "grouped" table - support to have a COMMA inside a search or replace column (declare them as |,|)
  • Export to TXD-DCTX button added in SQL environment Task
  • SQL environment - process is quicker as only 1 record is read from Table (and the user can read X records at will AFTER it is displayed)
  • Link by Name during a data Transfer links sql reserved word changed column names
  • New CAPITALIZE function for better "real life" processing
  • Clone to DAT - DBF - "re-linked" Data Transfer Task after a successful clone
  • Mapping Options - External Search & Replace Table allows an EMPTY Replace value
  • Clone to SQL when a MEMO column from source is changed to a VARCHAR
  • Mass Update when using EIP could result in all changed records not being saved back to File
  • Create from TXT code revised
  • Reading a TPS Table where a Column uses a PICTURE Token (ie: @PxxxxxP)
  • Cloning to SQL when a KEY contained Column Names surrounded by quotes , they are now deleted
  • Clone to SQL and the source Table did not have a Primary KEY

New in Data Management Center 1.6.0.8 (Jul 29, 2009)

  • During Data transfers use Mapping options AND COMBINE Conditions (record level) on the same column.
  • Perform on a given column a Mapping Operation or Concatenation or Replacement AND also define on the same (or other) column CONDITIONS to use at record level.
  • All SQL Table reading is faster (pre-loading).
  • NEW Mapping Options during Data Transfers : Parse First Second and Last (extract WORDS from a string)
  • NEW Drop Down boxes (.NET styled) in ODBC connection creation and in Settings.
  • External "grouped replacements" table import supports DUPLICATE checking (or not) from a choice message.
  • Portable version creation is simplified (XML is automatically copied and stored when DMC is activated) & activation is possible with an Expired activation XML file
  • Changed code to fix bug in Microsoft ODBC driver when SQL server 2008 DATE or TIME column are used.
  • Fixed bug during Cloning & Viewing when there are MEMO columns in a DBF Table.
  • Fixed bug in ODBC Connection Strings when Port was at 0 (missing end semi-colon).
  • Fixed bug when asking a table Creation from TXT Structure File.

New in Data Management Center 1.6.0.7 (Jul 29, 2009)

  • Reading an ASCII Table would create a GPF

New in Data Management Center 1.6.0.5 (Jul 29, 2009)

  • From Viewer when the user has a valid VIEWER level license he can export ALL records to CSV & XML.
  • ODBC Connection record fixed bug in the string "server" not being displayed

New in Data Management Center 1.6.0.4 (Jul 29, 2009)

  • From Viewer & Clone to & Data Transfer tasks : EXPORT the Structure to TXD & DCTX formats to import in Clarion dct.
  • HIDE UNHIDE Columns in the Viewer and TOGGLE formatting from LONG to DATE or TIME directly in a new module
  • VIEWER now supports KEYLESS TPS - DBF - DAT Tables and allows you all modifications
  • Windev Hyper Files can used as DESTINATION & Viewer WITH all options (save to File - Mass Update - QBE etc...)
  • Viewer - main frame toolbar drop down box : change the "After Enter key action" when in EIP mode to ease your work
  • During a Cloning task (non SQL's) you will be asked in WHICH FOLDER (works also on LAN) to create the New Table
  • In Viewer the HIDDEN columns in CSV & XML & all Predefined Exports : Hide a column and it will NOT be exported
  • Cloning a Table task : after the data is transferred DMC will automatically open the selected Destination folder for you.
  • Transfer to SQL DateTime Columns "link by name" => either STRING() or DATE & TIME (unused cols. are hidden)
  • During Cloning when there are BLOB columns : the size was not be set properly and displaying was giving problems
  • Viewer and Transfered data tab when a table contained NORMAL GROUPS (not the Date - Time ones)
  • Several small bugs in cloning to SQL

New in Data Management Center 1.6.0.3 (Jul 29, 2009)

  • Added Feature : External Replacement table during Transfer in Mapping Options (allows multiple "grouped" Search & Replace values for replacement within a column) WITH UPPER option
  • Added Feature to Password protect the ODBC module (in settings under 'DMC')
  • Added in Mass Update and in Data Transfer the possibility to CAPITALIZE data
  • In Mass Update changed the layout and added descriptive texts to help users
  • In QBE added buttons to check the validity of a query and changed the layout (step1 - step2 - step3)
  • Added in Mass Update and QBE automatic replacement of "Expression" in all functions with column name worked on
  • In QBE added descriptive texts to help the users while building queries
  • In Mass Update and QBE added automatic popup message to save the query created
  • Added after a CSV or XLM export from Viewer a button to open the destination folder for the user to 'take' the created file and use it
  • Added the Expiry Date of Maintainance Plan in main screen after license text
  • Fixed bug in Mass Update and QBE on tables with GROUPS
  • Fixed a bug in Extension module where the drop down would not let user select a value - replaced with entry EIP field
  • Fixed a bug in Oracle & FireBird cloning (key's)

New in Data Management Center 1.6.0.2 (Apr 15, 2009)

  • Changed array fields naming convention - array[1],array[2] etc...
  • Added feature for DMC to run several instances at the same time (Viewer in one and Transfer in another etc ....) all temp tables are timestamped
  • Added a setting to delete or not all temp tables when closing DMC
  • Added feature in Create from TXT File to create DBF or DAT tables also (plus TPS)
  • Added feature in Create from TXT to allow preprocessing and DMC will check Column types etc depending on the Driver used (Merci Vido)
  • Added feature in Create from TXT : now several "Executions" are possible to rectify if need be or create several variants of the table to test
  • Added feature to allow ODBC Access (and other SQL's) table reading & cloning when it contains illegal column or key names (like accentuated letters)
  • Added feature of automatic deletion of all old temp tables (after 3 days) used by DMC
  • Added feature in Create from TXT for preprocessing checks on Key Name LENGTH (DBF)
  • Entirely rewritten Mass Update and QBE Tabs to display properly when the OS did not have Themes turned ON
  • Added feature to support schemas in Oracle
  • Added feature of complete HyperFile tables support in all SOURCE tasks without using an external Wizard (rewrite of our library)
  • Added feature when an Access Table contains EMPTY Memo Names
  • Added feature to check TPS Total record SIZE when exceeding 15 k limitation - with automatic CHANGES applied by DMC to overcome this situation
  • Added in Navigation Panel a link to web site page on "HowTo" do's - Step by Step explanations
  • Added feature in main Wizard to display or not (from a new setting) ballooned tips with RIGHT CLICK possibility to open up directly web site HowTo page
  • Added setting to display or not those balloon tips in Main Wizard
  • Added feature of Main Frame resizing to default size - this will automatically resize and re center the screen)
  • All windows now have their OWN CLOSE button : careful : a learning curve might be necessary as the main frame top left button always closes DMC itself
  • Added feature for Evaluation users to test the Portable Version
  • Added setting to display balloon tips or not in all DMC
  • Added balloon tips throughout DMC with the use of a new class
  • Added NEW FEATURE of complete Themes support in DMC - define your own Themes and define ALL colors (with automatic restart after applying)
  • Redesigned the Registration module
  • Changed all the Create from TXT task which now opens up the TXT in DMC and allows for copy pasting - "live" modifications and several Tables created with different Drivers from the same script
  • Changed the main Wizard to now use Radio buttons and mainly all tasks are separated in 'types'
  • Changed ODBC "Test connection" button code to speed up the process
  • Changed the minimum Main Frame window size to avoid problems
  • Changed the Portable version module display
  • Redesigned the Settings module
  • Changed license activation success message and added an automatic restart of DMC
  • Added a Close button in the mapping tab to end a task without any transfer
  • Added TimeStamping for all temp BLOB Tables
  • Fixed a SendTo bug when exporting to Office 2007 Excel
  • Fixed bug in Creation Wizard when using "Open existing" where the wrong directory was used
  • Fixed a bug when Transferring with BLOBS would crash if the size was at 0
  • Fixed a bug in Viewer when exporting to CSV
  • Fixed bug in SQL environment when using MySQL version 4
  • Fixed bug in Viewer on a DAT Table with missing keyFile to launch an automatic rebuilding of that Key
  • Fixed a bug in Portable version creation and synching
  • Fixed a bug when cloning to Oracle and Firebird on UNIQUE KEYS
  • Fixed a bug in Structure tab when loading a table

New in Data Management Center 1.6.0.1 (Mar 12, 2009)

  • Added support of Multi Columned Primary KEYS in the Viewer (user can also update columns within the KEY)
  • Added support of Multi Columned Primary KEYS during data Transfers (select the FIRST column of the KEY and define it as an update column - DMC does the rest for you)
  • Support for full Drag & Drop in main module from Windows Explorer to open a Table
  • Use existing instance of DMC when asking for a table reading from Windows Explorer (if no process is running in the existing instance)
  • Added full support for MySQL version 4
  • Created a full clean-up utility (available on our web site on the download page) to help reinstall DMC
  • Support in Viewer to be able to read only the FIRST "X" or "Y" LAST records and also between record "Z" and record "T"
  • Added profile ID column in Project & profile module to better use the command line option
  • Added "end of process" .ini file writing in DMC to allow you to "drive" DMC from your application when using command line options.
  • Added default mapping option of generating a GUID()
  • Added default mapping option of generating a Replicate (capesoft) GUID
  • Added Visual Indicators on all entry fields for better user interface usage.
  • Added support for all existing CHAR SETS in Settings/Setup module to allow DMC to read and display properly all "foreign" characters (Greek - Chinese - Hebrew etc...)
  • Added support of MEMO columns in DBF Tables
  • Added a setting to define the LENGTH of String to use when displaying a MEMO column in the Viewer
  • Added setting to turn SQL Tracing AND ODBC Tracing On/Off when transferring data
  • Added an automatic BUILD KEY's after a Clarion DAT file Viewer update (column values modifications)
  • Added a protection in Viewer (updating a Table) : if DMC cannot locate the record changed then a LOOP on the Table is done and if again the record is not "found" then it BREAKS out of the updating.(generally this means the KEY needs rebuilding)
  • Added support to add to Most Recent Used list any DROPPED table in DMC to read it.
  • Changed HyperFile way of working : now all is "in" DMC as for other Tables and Viewing - Cloning and Transferring data are as easy as can be
  • Added support to check for Illegal Column Names (mainly for HyperFile) : if a Key or Column contains accentuated characters it is then still possible to View or Clone and transfer the Data.
  • Added in the Wizard a "locator" search entry field to make locating your tables easier.
  • Added support for Tables containing BLOBS (when Table total size is bigger then 2GB) : now the temp Tables are split in 250 MB chunks and this highly accelerates all readings.
  • Added support to store the Source and Destination Directories in the Wizard (no more looking for your "special" directories all over the machine or lan) : select them and automatically come back to them.
  • Support for full Drag & Drop of Activation XML file under Vista.
  • Removed all screen flickering (caused by balloon tips)
  • Changed all Icons.
  • Modified SOURCE and DESTINATION directories handling : now they are stored in memory and offered as default for the next read - when using either Viewer or data transfers.
  • Added in Viewer a message stop when modifications are done in a Table and the user closes the module without saving to File.
  • Changed in new Installations : default to read only first 50 records during a Transfer.
  • Changed directory for Temp BLOB tables from cgf_import to Windows temp directory (USB portable and small partitions).
  • Changed in Transfers : when no Updating is done, DMC will not read the Destination data (when the setting "read only 50 first records" is used).
  • Added support while Cloning to SQL in Oracle for all INDEXS to be created.
  • Fixed Clone to SQL (Access) missing end ')'.
  • Fixed After a data Transfer the SendTo button did not hold all data.
  • Fixed Clone to SQL (PostGre SQL) created KEYS where not seen and displayed on screen.
  • Fixed bug during Cloning to SQL : only the first 50 records were transferred (if the setting was used).
  • Fixed bug when reading only "X" records in the Viewer (SQL tables).
  • Fixed bug when reading DBF tables on KEYS (length of string container was too small)
  • Fixed bug when a Clarion DAT Table was used as destination.
  • Fixed another bug in DBF Tables KEY reading.
  • Fixed a bug in Table Creation Wizard : changing a Column Name which was in a KEY and was not automatically changed in the Key.
  • Fixed bug in Clone to SQL on MEMO columns bigger then 8000
  • Fixed bug when displaying BLOB columns in SQL Tables.
  • Fixed bug in Viewer Locate and Next functions.
  • Fixed bug in Clone to Clarion DAT (on STRING columns)
  • Fixed bug in Clone to DBF on Column Names bigger then 12 characters.
  • Fixed bug in MsSQL Tables where all KEYS where not read properly (same problem fixed while cloning to SQL Anywhere)
  • Fixed bug accessing Excel Tables (connections could not work properly)
  • Fixed bug in Viewer when sorting by Multiple Columned KEYS
  • Fixed bug in Mass Update and QBE where the "Load" button did not appear on screen.
  • Fixed bug in Clone - Transfer to ASCII on STRING length bigger then 255 characters.

New in Data Management Center 1.5.0.5 (Nov 14, 2008)

  • To support HyperFile, we had to create a new independent executable just for the Wizard and we added a new Setup - Settings parameter to let you define if you need working on those Files (to open either or Wizards).
  • In all Table reading we increased the number of columns from 999 to 9999 as it could result in column names being badly reported and GPF's during a cloning process.

New in Data Management Center 1.5.0.3 (Oct 23, 2008)

  • Enhancement : Added in Operations during a Transfer : LEFT - RIGHT and SUBSTRING portion extraction
  • Fixed Bug : Portable Version creation and synching

New in Data Management Center 1.1.0.6 (Feb 28, 2008)

  • Bug Fix : when a BLOB is found in source Table it is stored in full BINARY to a temp TPS table and is transferred from there to your destination table
  • Bug Fix : when an XLS sheet is source then if a REAL is found an NO decimals it is converted (clone to TPS) in a LONG
  • Bug Fix : when an XLS sheet is source then the Clone to TPS or SQL table name is now without the trailing $ sign