•Knowledge of SQL syntax is NOT required (except for manual sql queries) , all is automatically done for you.

•Rapid data migration across databases ensuring data integrity with no loss of data.

•Migrate & Transfer data across databases deployed on different platforms (Windows® operating systems or Unix or Linux).

•Migrate & Transfer data locally or on distant servers.

•Provides an uniform approach for migration across different databases.

•Save you specific settings & mappings in Profiles for further use and time saving.

•A few clicks will let you clone ANY source structure to SQL or TPS (with a user modifiable script)

•Easy to install and easy to use tool with user friendly WIZARDS & intuitive User Interface.

•Generate any quantity of random test data.

•Open an existing Table, launch or restore a saved Query to obtain a subset, then export this subset 'as is' directly to many predefined formats

•Use DMC Viewer as a very powerful Multi Format Viewer than can replace many different software programs, keeping your development tool cost low

•Use DMC Viewer to open ANY table and add/delete records (TPS/MsSQL/MySQL only) on the fly

•Use DMC Viewer to open ANY table and modify any column in any record etc...

•Use DMC Viewer to EMPTY any table (all) or to BUILD all the keys (TPS & DAT)

•Use DMC Portable to work at your clients sites

•Use DMC as an SQL environment Tool (switch between ALL registered DBs and list Tables, Keys & Columns, use an SQL Query Builder (save subsets to tables), switch to Full Viewer, etc.)

•Use DMC as Table Updater: for example, keep your Price Lists current from any odd source files by using the update possibility in column mappings.

•Take advantage of the full support for SQL BLOB columns

•Use the possibility to read - transfer or even create GUID columns in Pervasive and Ms SQL and SQL Anywhere and PostGreSQL

•Use DMC to work in Viewer on Tables with Multi Columned Primary Keys (even changing those column values from the key)

•Use DMC and define yourself the CHAR SET to use so as to be fully compliant with all foreign characters (Greek-Chinese etc...)

•Use Data Transfer (option to BULK INSERT) with Conditional Mappings AND perform at the same time on the same column Mapping Options such as Functions, Operations, Concatenations, etc.

•Pre Visualize immediately the destination data AFTER applying your mapping options and BEFORE transferring the data (save time)

•Export the FILTERED Transferred Data list (for example on all NOT Transferred ones)

•Use DMC to perform SQL DB level Backups (create "insert" scripts for all or selected tables) and have them zipped (password protected) and sent via FTP anywhere you need.

•Use DMC to perform SQL DB level or TPS/DAT FOLDER level (multiple files at the same time) clone to SQL Tasks

•Use DMC to generate for you a single TXD or DCTX (Clarion language) file of ALL tables cloned during such a Task.

•Use DMC to perform SQL DB level or TPS/DAT FOLDER level (multiple files at the same time) Data Transfer to SQL Tasks

•Use DMC to perform External Table LOOKUPS during a Data Transfer task when working on SQL tables (use data stored in Table B while transferring data to Table A from ANY source)

•Use all the power of DMC directly on your clients computers to perform any Task you predefine with the Runtime Engine Version (from Viewing tables to Data transfers or SQL Backups etc...)

•Use PostGreSQL server side DEFAULTS during Data Transfer Tasks

•Import - Export saved Projects and Profiles (for the runtime engine or between users)

•Use Functions (like SUBSTRING) in a Condition during mapping Options when Transferring data.

•SQL Server side DEFAULTS are now usable (in PostGreSQL to start) from DMC - let the server do the work!

•Compare STRUCTURES between a TPS/DAT-SQL table to another TPS/DAT-SQL table

•Compare STRUCTURES between a complete SQL Database to another SQL Database

•Compare STRUCTURES between an SQL Table and Multiple SQL Tables (inter-schema compares are also possible)

•Moving data to a new database : Cloning to SQL will create and copy data from one database to another (even across heterogeneous databases)

•Upgrading to new version of the database : Move data from one version of the database to another (ie: SQL Server to Oracle)

•Filtering Data (data sub setting): Migrate - Copy data based on simple as well as complex criteria(s).

•Data transformation: Migrate table and data applying wide range of mapping options.

•Options include, data type mapping, selecting specific columns, column mappings etc., that can be applied during migration

•Adding new data to existing database : Copy or add new data to existing tables in a database

•If you have data stored in any structure and simply need to quickly view it (deciding how many records to edit)

•If you have data stored in any structure and need to get it transferred into a different structure (using BULK INSERTS)

•If you need to migrate your data from ANY source to SQL or TPS - use the powerful feature of cloning tables

•If you need to create a new TPS or SQL table for immediate use - use the Creation Wizard

•If you need to be able to have a TPS table created from a TXT structure file

•If you need to be able to export to a text file (CSV or TXT) any existing data

•If you want to be able to filter records from being transferred using all the power of mappings

•If you have data stored in a table and need to modify and transfer some records to the same or different structure

•If you have a new client who wants his own data integrated in your application tables

•If you have existing data and need to merge it with other existing data

•If you need to instantly get a table converted to TPS and be able to import that table in your dictionary

•If you need to send data formatted in XML,WORD,HTML,PDF,XLS, etc. to a client; and it can be filtered and mapped as needed

•If you need to get on the fly a TXT file of the structure of your Tables

•If you need to have only one reliable tool to access ANY and ALL of your data tables

•If you need to visit clients and work on their data: use the Portable Version

•If you need to work on ANY SQL DB or table without changing tools for each SQL type (Queries on Single or Multi Tables and export subsets - Viewer - Data Generator etc....)

•If you need to UPDATE a table with values from other tables (use the UPDATE mapping feature)

•If you need to have your clients use DMC to transfer data from a command line argument Runtime Version

•If you need to export data from a Windev HyperFile to any other format

•If you are cloning a table to SQL and your source file contains DATE and/or TIME columns declared as LONG columns - DMC will detect those and allow you to change the type in SQL

•If you need to perform external lookups during any SQL data transfer

•If you want to let your end-users have an SQL Backup feature from your own application (Runtime Engine)

•If you want to let your end-users visualize any table from within your application (Runtime Engine)

•If you want to perform data tasks directly on your end-users computer (Price List updates in your tables from ANY source etc...) from your own application (Runtime Engine)

•If you want to Port your Clarion application from TPS to SQL and avoid having to learn about SQL reserved words and primary keys and date time groups