The driver supports migrating schema maps created with the 8.0 version of the driver so that they can be used by the 8.1 driver. By migrating these files, you can continue to execute the same SQL statements that you did with the 8.0 driver while leveraging the advantages of the 8.1 driver. Note that new objects discovered by the driver are mapped using the behavior of the 8.1 driver. See "Mapping objects to tables" for details.

Note: You can configure the driver to use the 8.0 name format for virtual foreign key columns for new objects by setting Legacy Virtual Keys (LegacyVirtualKeys) option to 1 (true). See "Legacy Virtual Keys" for details.
To migrate an existing 8.0 schema map and internal files, using the Schema Map (SchemaMap) option, specify the fully qualified path to the configuration file used for the 8.0 driver and set SchemaFormat to NormalizeAll. At connection, the driver migrates the content of your 8.0 schema map files so that they are compatible with the 8.1 driver. In addition, the driver creates copies of the original files in the same directory, if you want to continue using the 8.0 driver while you complete your upgrade. The copies of the original files take the following form:
<existing_file>-<file_version>.<extension>
For example, version 2 of a file named myserver.config would be renamed:
myserver-2.config
Note: The versions of the configuration files and internal files are not synched. Therefore, the files will likely have different numbers appended to the them for the 8.0 versions of the files.
Using migrated schema maps and internal files have the following limitation:
  • The driver supports only normalized relational views (SchemaFormat=NormalizeAll) for migrated schema maps and internal files.
  • The driver does not support migrating maps for flattened views; however, the flattened views generated for 8.0 and 8.1 are very similar and should support many of the same SQL statements. You can further modify your flattened view to support SQL statements for earlier versions by configuring the Flatten Array Base (FlattenArrayBase) and JSON Columns (JSON Columns) options.