CTREE Databases are a legacy database format that has been used by some applications.  In order to work with them, you'll need to do the following:

1. Install CTREE ODBC Drivers
2. Create a "Table List"
3. Configure the ODBC Drivers to use the Table List
4. Use Full Convert to access the database and convert it to MSSQL.

1.  Installing the CTREE Drivers

The CTREE Drivers are attached to this article.  Download and install them.

 

2.  Create a Table List

Each CTREE-based application stores its data files in different locations so you will need to refer to each application individually, however, the table list will be a regular file that will have content similar to the following:

TABLENAME001        E:\DATA\SOMEPATH\TABLENAME001.DAT
TABLENAME002        E:\DATA\SOMEPATH\TABLENAME002.DAT

The table list must use absolute paths to the data files.  If your table list does not have absolute paths, update it so that it does.

 

3.  Configure ODBC Drivers

The CTREE ODBC Drivers are 32-bit drivers and as such, can only be used by 32-bit applications.

To connect to your table list, open the 32-bit ODBC Data Sources on your PC:

Then add a new System DNS:

And select the FairCom 32-bit ODBC Driver:

The settings for each application's database will be slightly different so you should refer to the documentation for each specific application, however, some settings are common:

Data Source Name (aka "DSN")

This is the ODBC name you want for your database.  Any name will do.

Script Name

This is the filename (without the path) of your table list file.  It might be named something like FAIRCOM.DB, MyDatabase.txt, or MyTables.  Just make sure that if you open that file, you see content similar to what was described in Step #2.

Data Dictionary Path

This is the path (without the file name) of the table list you created.

4.  Convert the Database to MSSQL

You can now use the 32-bit version of Full Convert by Spectral Core to convert this database from ODBC to SQL Server.