 |
|
DMC Main Features
Data Migration Tool Features:
- Supports migration & transfer of data across SQL Server, MySQL, Oracle, IBM DB2, SQL Anywhere, PostgreSQL, Pervasive SQL, Firebird , MS Access.
- Migration & Transfer of data from Excel, DBF, DAT, TPS and CSV (Comma Separated Value) files into databases.
- Migrates tables, indexes, constraints (depending on destination SQL) along with data .
- Supports advanced features for Data mapping during migration
- Criteria based data migration (data subsetting) 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 matching the criteria (subset) will be migrated.
- If multiple criterias are set for a column, then the order in which they are defined will be used while migrating the data.
|
|
|
|
|
|
|
Use DMC as a generic file VIEWER
|
Export directly your data to XML - XLS - CSV - PDF - HTML - Word
|
|
|
|
|
|
|
or use DMC to Generate Data for test tables
|
|
|
|
|
|
|
|
|
|
|
|
or Use all the power of DMC ...
|
|
|
|
|
|
|
|
|
|
|
|
Select your SOURCE Driver
|
|
|
|
|
|
|
|
Select your SOURCE DB or Table
|
|
|
|
|
|
|
|
or 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 with .... (click here to see them -->)
|
|
..... and Transfer your data
|
|
|
|
|
|
Visualize the Transferred data immediately
|
|
|
|
|
|
|
