Introduction > Features Overview

DMC Features:

•	Supports migration & transfer of data across SQL Server, MySQL, Oracle, IBM DB2, SQL Anywhere, PostGreSQL, Pervasive SQL, Firebird , MS Access - Windev HyperFile.

•	Migration & Transfer of data from Excel, DBF, DAT, TPS and TXT or CSV (Comma Separated Value) files into databases (with full support of arrays)

•	Migrates tables, indexes, constraints (depending on destination SQL) along with data .

•	Supports advanced features for Data mapping during migration

•	Multi Criteria based data migration (data sub setting) is supported when migrating to any database.

•	User can set the filter criteria for record(s) or column(s) based on which, only the rows or columns matching the criteria (subset) will be migrated.

•	If multiple criteria's are set for a column, then the order in which they are defined will be used while migrating the data.

•	Use DMC as a Viewer for any Table either directly opened with a double-click from Windows Explorer or from within the tool itself

•	Use DMC Viewer to access edit and change any non Binary BLOB (even in SQL tables)

Use DMC as a generic Table VIEWER (Export directly your data as is to XML - XLS - CSV - PDF - HTML - Word)

dmc_viewer_gen

Define your CHARSET to visualize ANY foreign language file (example in Russian)

dmc_charset_russian

Use the facility of a real Edit In Place for your columns (with a built in calendar for Dates - and special BLOB Viewer)

Change your DATE Column with a calendar popup ....

Visualize your non Binary BLOBS directly - you will be able to Extract them to HD or insert new ones ....

Visualize your BLOBS (insert or change them) with embedded pre viewers for Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC - XLS documents

viewer_bob_pdf

viewer_bob_image

or use DMC to Generate Data for test tables

(when you work on an SQL table with GUID columns those will be generated for you by DMC)

Use all the power of DMC : select your task

dmc_source_small

Select your SOURCE Driver

dmc_source_tps

Select your SOURCE DB or Table

dmc_source_sql

then Select your DESTINATION Driver

Clone to SQL or TPS your Source Table

or Select your Destination Table

Visualize your Source and Destination File STRUCTURES

Do your Mappings and Transfer your data

dmc_general_s

Apply multiple Functions or Concatenations or Replacement "groups" (and eventually conditions) on the same column (or several)

dmc_multiple_functions

Perform EXTERNAL Table LOOKUPS during a data Transfer task to SQL

dmc_external_lookup

Visualize the destination data BEFORE Transferring but WITH your mapping options APPLIED

dmc_mapped_data

Visualize the Transferred data immediately (export a filtered list using the Send To button)

dmc_transferred_data_small

or use the configurable command line feature to pilot DMC saved Projects or Profiles

dmc_command_line