Have an app in D4 and using dBIsam ver.2.12. I would like to migrate data into D6 and ver.4.x. Tables are not same, so I will have to write an
app for this since I have quite a few customers and I need an automated tool for this migration.
I would like to have an app which will read ver.2.12 and write into 4.x.
Please advise since only that I can think of is write 2.12 into TXT and then read into 4.x

andrej

Andrej,

<< I would like to have an app which will read ver.2.12 and write into
4.x. >>

You can upgrade the table format from your DBISAM 4 application using
the TDBISAMTable.UpgradeTable method. You can get more information here:
http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=6&category=1&topic=16

You can also do it using SQL:
UPGRADE TABLE [IF EXISTS] table_reference
Please read the details here:
http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=6&category=3&topic=22


--
Fernando Dias
[Team Elevate]

andrej

>Have an app in D4 and using dBIsam ver.2.12. I would like to migrate data into D6 and ver.4.x. Tables are not same, so I will have to write an
>app for this since I have quite a few customers and I need an automated tool for this migration.
>I would like to have an app which will read ver.2.12 and write into 4.x.
>Please advise since only that I can think of is write 2.12 into TXT and then read into 4.x

In V4 there is a table method UpgradeTable which may work. I don't have any V2 tables left to try it on, but it should be as simple as tablename.updatetable.

From the V4 manual

1.1 Changes From Version 3.x
The following items have been changed in Version 4.x from Version 3.x:
• The physical table format has changed for version 4 and all tables in 3.x and earlier formats will require upgrading
to the current format using the TDBISAMTable UpgradeTable method or the new UPGRADE TABLE SQL statement.
Please see the Upgrading Tables topic for more information.


Roy Lambert [Team Elevate]