Migrating Files using the Command-line¶

Command-line syntax¶

Select Mertech’s ISDBC Drivers for Btrieve | Mds Migrate Table from the Windows Start menu. Since this is a command-line utility, a Command Prompt is automatically opened

Run the MdsMigrateTable script by typing the following at the command prompt:

MdsMigrateTable tablelist operation ddf [configuration parameters]

Tablelist determines which Btrieve tables are involved in the migration process. The tablelist parameter is required.

Operation determines which piece(s) of the migration to perform. The operation parameter is required.

NOTE: INT files are created in the same location as the data files unless they are redirected to another folder by the mds.ini file.

ddf is the full or relative path to the data dictionary files (DDFs). The ddf parameter provides the source for the conversion and is required.

/ddf <DDF Folder>

Configuration parameters are settings used during the migration process. Configuration parameters are optional unless otherwise indicated.

NOTE: If the server, target database, and/or login credentials are not provided, the mds.INI file, registry settings, or Login dialog box provide these details.

XML Config File¶

The /config parameter can be used to pass the name of an XML config file that contains settings that affect the conversion process. For instance, whether to remember the server name in the INT file, the Oracle tablespace settings, or whether a field is nullable. If no /config parameter is provided the driver’s default settings and the information obtained from the DDFs and the data file itself are used.

You can use the XML config file to override default conversion settings. You only need to include the pieces to be changed. For example, if you want to change one of the fields to not be nullable even though the DDFs are flagged as nullable you might provide the following XML config file.

<Btrieve2SqlMigration Driver="SQL_BTR">

  <Table Name="Updates">

    <Fields>

     <Field Name="C1" Nullable="n"/>

    </Fields>

  </Table>

</Btrieve2SqlMigration>

A Table entry with no table Name specified overrides the default settings for ALL tables. A Table entry with a specific Name indicated overrides the default settings. So you can have a no table name entry with OverwriteExistingTable=yes and then for table “person”, specify OverwriteExistingTable=no.

If you are migrating a uniPaaS application and the source is stored in XML format, you can generate the XML config file automatically using the MigrateUniPaasData command-line tool. You can then edit the generated file to meet your needs. You can also create the XML config file manually.

NOTE: Refer to the <Program Files>\Mertech Data Systems\DB Drivers\Btrieve\sdk\samples\migration folder for sample XML files and the DTD, which contains the legal building blocks for the XML config file.