Product Home
DTM Migration Kit Online Documentation Prev Page Prev Page
General information
Product profile
User interface
Quick start
Transformation rules
Scheduling
How to...
Settings
Data preview
Command line
Console mode
Project properties
Rules
Data source
Clear object
Mapping
Functions in Mapping
Data Type Mapping
Execution control
Export options
Source type
Import options
Schema migration
Rule information
Source object
Target table
Send e-mail rule
SQL files
Records Mode
Additionals
Database utilities
Installation
Uninstal
License
How to order
Technical support
Glossary

Migration rules

You must create a migration project to perform any data transformations. A project is a set consisting of one or more rules. There are ten types of rules. They are:
  1. Data migration allows you to perform data transformation between two data sources.
  2. Export data allows you to export data from a database table to the HTML, XML, text or RTF (MS Word compatible) format.
  3. Import data is a way to import data from desktop formats (text, DBF, Access, Paradox, Excel) to a database table.
  4. Clear data can be used to drop the selected table or to delete some specified rows.
  5. Schema migration allows you to create empty copies of tables, views, indexes and keys in the destination database.
  6. Conditional branching changes the order of execution depending on whether the result of the previous step is OK or FAILED.
  7. Go to label is unconditional execution branching.
  8. Stop execution interrupts project execution.
  9. Run external executable allows you to run any external executable.
  10. Run SQL script allows you to run SQL scenario from disk file.
Please use the dropdown toolbar menu to create a new rule. It opens the Rule Wizard that helps you to create a rule.

You can specify an optional label for any rule. It can be used for jumping to this rule from any other rule. Moreover, you can add a text comment for a rule.

Limitations of the current version

  • Text fields are limited in their length to 20480 bytes for all migrations (import, export or data transfer).
  • Schema migration for triggers and for stored procedures is not supported.
  • Views migration is not supported for some database formats (MS Access etc.)