Detailed Features

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, TXT or CSV 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 records or columns based on which, only the rows or columns matching the criteria (subset) will be migrated.

If multiple criteria 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 DMC 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 your data as is directly to XML - XLS - CSV - PDF - HTML - Word)

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

Use real Edit In Place to modify your columns

Edit your DATE Columns with a calendar popup

Visualize, insert and change your BLOBS with embedded previewers for Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC - XLS documents

Use all the power of DMC

Select your task

 

 

Select your SOURCE driver and database or table

 

 

Select your DESTINATION driver and table.

 

 

Clone to SQL or TPS your Source Table or select your Destination Table

 

Visualize your Source and Destination File STRUCTURES

 

Define your Mappings and Transfer your data

 

 

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

 

 

 

Perform EXTERNAL Table LOOK UPS while transferring data to SQL (extract data from another Table - Parent-Child)

 

 

Visualize (ie, view) the destination data BEFORE beginning the actual transfer so that you can see what the result will be with your mapping options applied.

 

 

Visualize the transferred data immediately by exporting a filtered list using the Send To button

 

Use the saved Projects and Profiles