4. Spatial Data Migration

This chapter describes how to migrate spatial data between Altibase products or from/to other database vendors.

Spatial Data Migration Between Altibase Products

To perform spatial data migration between Altibase products, you can use iLoader and aexport. Since both tools support spatial data, migration can be carried out in the same manner as for other data types.

One important consideration is the format Altibase uses to store spatial data. Based on the SYSTEM_.SYS_DATABASE_ table, Altibase versions prior to 8.8.1 use the WKB (Well-Known Binary) format, while version 8.8.1 and above support the EWKB (Extended Well-Known Binary) format. The format of the spatial data extracted during migration depends on the version of the source Altibase instance.

An Altibase version that supports EWKB can read and automatically convert WKB-format spatial data. However, an Altibase version that only supports WKB cannot recognize EWKB-format spatial data. Therefore, when migrating EWKB-format data to a WKB-compatible Altibase version, you must extract the source data in WKB format.

To do this:

Set the following option in the aexport.properties file when using aexport: - ILOADER_GEOM = WKB

Or, when using iLoader for a single table, use the option: - -geom WKB

For more details, refer to the iLoader and aexport manuals.