|
You should create a migration project to perform any data
transformations. A project is a set of one or more rules. There are
eleven rule types:
- Data Migration allows you to perform data transformation
between two data sources.
- Export Data allows you to export data from a database
table to HTML, XML, text or RTF (MS Word compatible) format.
- Import Data is a way to load data from desktop formats
(text/csv, DBF, Access, Paradox, Excel) to a database table.
- Clear Data can be used to drop the selected table or to
delete some specified rows. Also, it allows to drop view or stored
procedure.
- Schema Migration allows you to create empty copies of
tables, views, indexes, triggers, procedures, keys, etc 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
program or system batch file.
- Run SQL Script allows you to run SQL scenario from disk
file for specified database connection.
- Send e-mail allows you to send a message via default
mail client.
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).
- Views migration is not supported for some database formats (at
least Microsoft Access)
|
