Root Element

The root element identifies the XML variant and sets global migration options.

Btrieve2SqlMigration

Used when Btrieve DDFs are available. The DDFs provide the base table, field, and index definitions. The XML overrides or supplements those definitions.

<Btrieve2SqlMigration Driver="SQL_BTR"
                      SqlScriptFilename="c:\data\script.sql"
                      ContinueOnError="n">
  <Table><!-- ... --></Table>
</Btrieve2SqlMigration>

Btrieve2SqlFullMigration

Used when DDFs are not available. All table, field, and index information must be fully specified in the XML.

<Btrieve2SqlFullMigration Driver="SQL_BTR">
  <Table><!-- ... --></Table>
</Btrieve2SqlFullMigration>

Root Element Attributes

Attribute

Required

Default

Description

Driver

No

(none)

Specifies the intended target SQL driver. The migration will verify that the loaded driver matches this value. If omitted or set to GENERIC, the XML is considered valid for any driver. Accepted values:

  • SQL_BTR — Microsoft SQL Server

  • ORA_BTR — Oracle

  • PGS_BTR — PostgreSQL

  • GENERIC — Any driver (Full Migration only)

SqlScriptFilename

No

(none)

Path to a SQL script file to generate. When set, the migration can produce a SQL script containing the DDL statements instead of (or in addition to) executing them directly.

ContinueOnError

No

y

Controls behavior when an error occurs during migration.

  • y — Skip the failed record or table and continue.

  • n — Stop the migration on the first error.

Child Elements

The root element contains one or more <Table> elements. See Table Element for details.