|
How to...
|
|
|
| Transformation task
|
Solution
|
| Import, export or migrate the single table or view. |
Create "Import", "Export" or "Migration" rule. |
| Import, export or migrate all tables to a new (empty) data
source. |
Create "Import", "Export" or "Migration" rule with "All tables" mode. |
| Export or migrate the results of query execution. |
"Export" or "Migration" rule and enter "SELECT" statement for
query definition. |
| Import, export or migrate a few tables. |
Create "Import", "Export" or "Migration" rules for each source
table. |
| Import or migrate data to the existing table with data
overwriting. |
1. Create "Clear" rule.
2. Create "Import" or "Migration" rule. |
| Perform migration rule(s) and send notification if
success. |
1. Create your migration rule(s).
2. Create "if" rule for FAIL.
3. Create rule with run an external notification. |
| Run project without any prompting. |
1. Create and save your transformation project.
2. Run Migration Kit with -c switch and project file name as a
command line. |
| Scheduled package execution. |
1. Create and save your transformation project.
2. Schedule project execution using "Schedule" dialog. |
|
|
|
|
© Copyright 2003-2010 DTM soft.
|
