Migration XML Configuration Reference

BTR2SQL uses XML configuration files to control how Btrieve tables are migrated to SQL databases. These files define which tables to migrate, how fields and indexes should be mapped, and what options to apply during the migration process.

There are two variants of the XML format:

  • Btrieve2SqlMigration — Used when Btrieve Data Definition Files (DDFs) are available. The DDFs provide the base table structure, and the XML overrides or supplements specific settings.

  • Btrieve2SqlFullMigration — Used when DDFs are not available. The XML must fully define every aspect of the table, including all fields, data types, offsets, sizes, and indexes.

Both variants share the same general structure and most attributes. The Full Migration variant requires additional attributes that would otherwise come from the DDFs.

Note

DTD files are provided with the SDK samples for validation purposes. However, the DTDs may not reflect every attribute supported by the current version of BTR2SQL. This reference documents all attributes recognized by the software, including those not yet added to the DTDs.