High-Speed Script Based Migration¶
Several databases include a utility that allows the use of text files to populate tables. Flex2SQL has an easy to use feature called Create Text File for Loader that generates the text files and all the necessary script and control files needed for migration using this utility.
Note
The Create Text File for Loader option is available for Oracle, PostgreSQL, MySQL and MariaDB.
There are two ways to use the text-file loader option.
Let Flex2SQL perform all the tasks except for loading the data
Flex2SQL |
DBA |
Flex2SQL |
||
|---|---|---|---|---|
1 Create empty SQL table(s) and INT file (s) 2 Generate txt, bat and ctl files |
⇒ |
Run server-specific loader |
⇒ |
Run Analyze After Loader |
Let Flex2SQL generate scripts so a DBA can perform the tasks
Flex2SQL |
DBA |
Flex2SQL |
||||
|---|---|---|---|---|---|---|
1 Generate SQL script for creating table(s) 2 Generate INT file(s) 3 Generate txt, bat and ctl files |
⇒ |
1 Run SQL script to create table(s) 2 Run server-specific loader |
⇒ |
Generate script to analyze loaded data |
⇒ |
Run post loader script to analyze loaded data |
Note
After each loader execution, you must run the option (x will be the database backend) for each migrated file. THIS IS VERY IMPORTANT. This option analyzes the system and adjusts the RECNUM values to run properly with DataFlex. If this option is not executed FIND commands behave erratically.
This option is also found in the shortcut menu in the Shortcut menu in the Filelist dialog.
Methods of Migration