Navigation:  Introduction >

Detailed Features

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text
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)

Define your CHARSET to visualize ANY foreign language file (example in 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 BLOBS (insert or change them) with embedded pre viewers for Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC - XLS documents

Use all the power of DMC

select your task

 

 

select your SOURCE Driver

 

 

select your SOURCE DB or Table

 

 

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

 

 

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

 

 

 

Perform EXTERNAL Table LOOKUPS during a data Transfer task to SQL

 

 

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

 

 

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

 

Use the saved Projects and Profiles

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.