Introduction > Detailed 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, 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)

•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