Product Documentation

FairCom RTG BTRV User Guide

Previous Topic

Next Topic

Data Conversion

Migrating Your Data to FairCom DB ISAM

Before your application is ready to use FairCom DB ISAM, the data must be converted to a format that can be used by FairCom RTG/ISAM. This is done by exporting data from your ISAM application and importing into FairCom RTG/ISAM. This is a one-time process that must be done before you can use FairCom RTG/ISAM.

FairCom RTG/ISAM provides a GUI tool to aid in migration, RTG Migrate, as well as a command-line utility, ctmigra.

Another way to migrate data is to use BUTIL to export from ISAM and ctutil to import to FairCom RTG/ISAM, as described in Converting ISAM Data to FairCom RTG/ISAM.

Files and File Names

Many ISAM files combine data and indexes in the same file. The conversion process will result in separate data and index files. If your ISAM file name includes a suffix, such as myfile.ved, you will see two files with these names: myfile.ved.dat and myfile.ved.idx.

If you want your data file to have the same name as your original, use the ctree.conf element <datafilesuffix> and set it to empty:

<datafilesuffix />

In this example, a ISAM file named myfile.ved will result in two files with these names: myfile.ved and myfile.ved.idx.

Configuring Your System

The information you enter into the RTG Migrate tool can be used to create a configuration file for your system. The final step of the migration wizard allows you to create and save a configuration file.

Much of the information you need for configuring your system is necessary for the migration process and will be entered in the RTG Migrate tool. If you system has additional considerations that dictate a more complex configuration file, you can use the procedures in FairCom RTG/ISAM Configuration to edit the file.

SQL Access

If you will be accessing your data using SQL, you will need to see FairCom RTG/ISAM SQL Access.

In This Chapter

RTG Migrate

Convert Microfocus ExtFH C-ISAM Tables with ctmigra

Converting ISAM Data to FairCom RTG/ISAM with butil/ctutil

TOCIndex