Navigation:  Introduction >

Features Overview

Previous pageReturn to chapter overviewNext page

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