Extracting the database schema with fgldbsch

The fgldbsch database schema extraction tool has been updated to map native database types to newly-added types.

Version 2.20 implements new data types such as BIGINT and BOOLEAN. The fgldbsch database schema extraction tool has been reviewed to map native database types to these new types when possible. Pay attention to these changes, when extracting a schema from your database.

For example, before version 2.20, fgldbsch converted an Oracle NUMBER(20,0) to a DECIMAL(20,0) by default. Now, since 2.20 provides the BIGINT native FGL type, it can be used to store a NUMBER(20,0) from Oracle.

You can get the previous behavior by using a conversion directive with the -cv option of fgldbsch.

To see the new conversion rules, run the fgldbsch tool with the -ct option.