|
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:
- Data migration allows you to perform data transformation between two data sources.
- Export data allows you to export data from a database table to the HTML, XML, text or
RTF (MS Word compatible) format.
- Import data is a way to import data from desktop formats (text, DBF, Access, Paradox, Excel) to a database table.
- Clear data can be used to drop the selected table or to delete some specified rows.
- Schema migration allows you to create empty copies of tables, views, indexes and keys
in the destination database.
- Conditional branching changes the order of execution depending on whether the result of the previous
step is OK or FAILED.
- Go to label is unconditional execution branching.
- Stop execution interrupts project execution.
- Run external executable allows you to run any external executable.
- 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.)
|
