Introduction > Main Features

Data Management Center will let you Visualize - Manipulate - Clone - Transfer all your Data at Table or DB or Folder level : it will read the Structure from the files-tables themselves and let you handle all necessary actions (or do it for you in most cases).

You will be able - for example - to open a client's Data Base Table and import all or part of their data in your application's Tables (different Structures - you just have to do your column mappings - but can use the auto link mode)....

You will be able to open a Table in ANY format and to CLONE it's structure to ANY SQL (or to TPS - DAT - DBF) ..... and then transfer all or part of your Data

You will be able (during a data transfer to ANY SQL Table) to perform EXTERNAL TABLE lookups to use the resulting values in the destination column selected

You will be able (during data Transfers) to link multiple conditions together and also to link them each to single or linked multiple Functions so as to normalize (or clean) your data.

You will be able to read ANY Table and Visualize it's content (also to export this data to many predefined formats (HTML - PDF - Word - CSV - XLS etc ... directly from onscreen display)

(a double-click on any DAT - DBF or TPS Table in Windows Explorer will open the file for you with DMC with all the features attached to this Multi Format Viewer )

You will have - in the same application - a complete multi SQL environment enabling you to View & Modify (sql queries you write) ANY SQL Data Base and all related TABLES and VIEWS

You will have the best available tool to Port your Clarion Application from TPS to SQL allowing full SQL compliancy of your CODE (with detailed HELP commented examples)

•	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 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 to 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 replacing many different separate softwares

•	Use DMC Viewer to open ANY table and add / delete records (TPS and Ms SQL - 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 Key's (TPS & DAT)

•	Use DMC Portable to work at your clients sites

•	Use DMC as an SQL environment Tool (switch between ALL registered DB's and list Tables - Key's & 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 .... (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 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)

•	NEW in version 2

•	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 machines to perform any Task you predefine with the Runtime Engine Version (from Viewing tables to Data transfers or SQL Backups etc...)

•	Use PostGre SQL 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 visualize 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

•	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 (and use immediately) a new TPS or SQL table - 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 some records and transfer only those 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 in other existing data

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

•	If you need to send some data in XML - WORD - HTML - PDF - XLS etc... format to a client (filtered & mapped if need be)

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

•	If you need to Horizontalize your data (transfer x records to x columns in 1 record)

•	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 and Tables without changing tools for each SQL (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 offer 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 machine (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 you having to bother about SQL reserved words and Primary keys and date Time groups

IMPORTANT : ALWAYS BACKUP YOUR DATA BEFORE WORKING ON IT - THIS WILL AVOID ALL EVENTUAL PROBLEMS YOU MIGHT CREATE WITH A MISUSAGE OF THIS TOOL !

How to get started

►	Start by walking through all features to see what DMC can do for you or look at detailed features

►	Study the User Interface and menus to familiarize yourself with the basics of the program .

►	Check out all the links in the Left Navigation Help tab – plenty of help is available!.

Learning more

►	See the Settings section for detailed instructions on configuring and using DMC.

►	See More Advanced Tasks for, you guessed it, instructions on more advanced features!

►	See the Port to SQL section for more detailed background information.