This file contains details of converting existing Easysoft ODBC version 
1.4/1.5 catalog definitions into Easysoft Data Access for ISAM.

Easysoft Data Access for ISAM stores its definitions within as set of files
referred to as a schema. 

By default the installation will have created a datasource EASYSOFT_ISAM 
with a schema_path of 

/usr/local/easysoft/isam/schema/        (non-windows)
InstallPath/Schema                      (windows)

To access the same ISAM files defined within Easysoft ODBC for ISAM within
Easysoft Data Access for ISAM entries must be made within the schema files.

This is achieved by using the convert binary supplied with this installation.

Non-Windows
===========

$ cd /usr/local/easysoft/isam/bin
$ ./convert

Running convert will give the following output

Easysoft ODBC for ISAM Catalog Extractor (Version 1.1).
Copyright (c) 1993-2003 Easysoft Limited.

usage : convert -c [catalog] -o [output filename]

  -c  Specify location of version (1.4/1.5) catalog to convert.
  -o  Output file to receive resultant data definition statements.
  -i  Do not check file specifications. Output all definitions.
  -drop  Generate drop table statements as well as create.

  example : convert -c /opt/easysql/democat -o output.sql -drop

  This routine extracts file definitions from an existing
  Easysoft ODBC for ISAM catalog and presents these definitions in
  the correct format to be imported into Easysoft Data Access for ISAM.

If you receive an error stating that the libesdisam_isam shared object 
cannot be found use the convert.sh script provided with the same arguments
as convert.
  
To successfully run the example line listed above you must setup the 
EASYSOFT_SQL_DEMO_DATA environment variable prior to executing the convert
command.

  $ EASYSOFT_SQL_DEMO_DATA=/opt/easysql/demodata
  $ export EASYSOFT_SQL_DEMO_DATA

Failure to set this environment variable will result in errors like  
'could not find file LASER or EASYSOFT_SQL_DEMO_DATA/LASER'

To convert your existing catalog simply follow the example above changing
/opt/easysql/democat to the location of your catalog.

Once the converter has run the file output.sql is created. This file contains
the sql statements required to create the definitions within the new schema.

To place these files within the easysoft_isam datasource simply perform the 
following :

$ cd /usr/local/easysoft/isam/bin
$ ./easysql -f output.sql

Your data files should now be accessible within Easysoft Data Access for ISAM.

To check this simply perform the following steps :

$ cd /usr/local/easysoft/isam/bin
$ ./easysql
conn = :DSN=easysoft_isam;UID=dbo;PWD=easysoft;SQICOUNT=1;...

> select * from info_schema.tables; (Press Return)

A list of all tables within the schema will be listing here;

Entering a blank line within easysql will exit back to the shell prompt.

Windows
=======

For the purposes of this installation the default installation directory
of C:\Program Files\Easysoft\Easysoft Data Access for ISAM will be used. If
during installation and alternate location was specified please adjust 
accordingly.


cd "\Program Files\Easysoft\Easysoft Data Access for ISAM"
convert.exe

Running convert will give the following output

Easysoft ODBC for ISAM Catalog Extractor (Version x.x).
Copyright (c) 1993-2003 Easysoft Limited.

usage : convert [catalog] [output filename]

  catalog :- Specify location of version (1.4/1.5) catalog to convert.
    output filename :- Output file to receive resultant data definition
    statements.

    example : convert "c:\Program Files\Easysoft\Democat" output.sql

    This routine extracts file definitions from an existing
    Easysoft ODBC for ISAM catalog and presents these definitions in
    the correct format to be imported into Easysoft Data Access for ISAM.

To successfully run the example line listed above you must setup the 
EASYSOFT_SQL_DEMO_DATA environment variable prior to executing the convert
command.

  SET EASYSOFT_SQL_DEMO_DATA="C:\Program Files\Easysoft\DemoData"

Failure to set this environment variable will result in errors like  
'could not find file LASER or EASYSOFT_SQL_DEMO_DATA/LASER'

To convert your existing catalog simply follow the example above changing
c:\Program Files\Easysoft\Democat to the location of your catalog.

Once the converter has run the file output.sql is created. This file contains
the sql statements required to create the definitions within the new schema.

To place these files within the easysoft_isam datasource simply perform the 
following (still in C:\Program Files\Easysoft\Easysoft Data Access for ISAM):

sql dsn=easysoft_isam output.sql

Your data files should now be accessible within Easysoft Data Access for ISAM.

To check this simply perform the following steps :

sql dsn=easysoft_isam
conn = :DSN=easysoft_isam;UID=dbo;PWD=easysoft;SQICOUNT=1;...

> select * from info_schema.tables; (Press Return)

A list of all tables within the schema will be listing here;

Entering a blank line within sql will exit back to the shell prompt.

