The SQLI2SQL piece of the KB_SQL package is the software that runs in conjunction with the Fileman SQLI patch. This process maps the Fileman Data Dictionaries into a KB_SQL Data Dictionary. The process flattens out the Fileman Files into relational tables. For example, a Fileman file that contains a multiple field will be mapped to a parent table with a primary key (usually the IEN of the Fileman File), while the multiple field will have a table created of it's own with the same primary key as the parent table.
The FM2SQL piece of KB_SQL was the original version of the Fileman mapper prior to the Fileman SQLI patch. The SQLI2SQL is an upgrade to FM2SQL.
The run the mapper from programmer mode you need to type D SETUP^KBF. It is a good idea to have your environment set up to DSM/SYM=1000000/SOU=65500. Below is an example of a successful run:
>D SETUP^KBFDefault DDL init file /SQLINI.DDL/: SQLINI.DDL
Default DDL table file /SQLTBL.DDL/: SQLTBL.DDL
Compile SQLI objects? /NO/: Y
Import schemas, domains and output formats? /NO/: Y
Import tables and indicies? /NO/: Y
Compiling SQLI objects...
Table 6561
Elapsed time: 03:33:20
Columns of 6561
Elapsed time: 12:10:27
Foreign key 7164
Elapsed
time: 13:10:08
Index 6561
Elapsed time: 5:11:35
Parsing DDL to build table import file ...
13027 / 13027 lines
Parse complete!
Importing data dictionary information...
Import complete!
Status 'COMPLETE' Elapsed time:
00:06:21
Parsing DDL to build table import file ...
351089 / 351089 lines
Parse complete!
Importing data dictionary information...
Status 'COMPLETE' Elapsed time: 06:01:13