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.)
|
