Migrating schema maps and native files to 8.1
- Last Updated: July 30, 2025
- 2 minute read
- DataDirect Connectors
- ODBC
- MongoDB 8.0
- Documentation
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.configNote: 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.