Hi,

I'm currently going through the process of trying to convert one of my
database applications to EDB, and have hit a problem.

I need to migrate the tables, and data from DBISAM 4 to EDB, but the
tables use a custom signature.

As such, I'm not sure where to go to from here. Unfortunately I can't
reverse-engineer the data in DBISAM because there are BLOB entries.

I've had a quick look at the source code for the DBIAM4 migrator and
notice that there is a section under EDBMigratorModuleGetParams for
EngineSignature but I can't figure out how to actually pass that parameter.

Thanks & Regards

Adam.

Adam,

<< I've had a quick look at the source code for the DBIAM4 migrator and
notice that there is a section under EDBMigratorModuleGetParams for
EngineSignature but I can't figure out how to actually pass that parameter.
>>

Did you check out this section of the manual ?

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=delphi&version=7&topic=Migrating_DBISAM_Database_Mgr

After you execute the migration using the EDB Manager, you can retrieve the
SQL that it used by using the Explorer/SQL History option from the main
menu.  Then you can see how the parameter is passed, etc.

This section also covers all of the particulars about migrating via code:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=delphi&version=7&topic=Migrating_DBISAM_Database_Code

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

<< I've had a quick look at the source code for the DBIAM4 migrator and
> notice that there is a section under EDBMigratorModuleGetParams for
> EngineSignature but I can't figure out how to actually pass that
> parameter. >>
>
> Did you check out this section of the manual ?
>
> http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=delphi&version=7&topic=Migrating_DBISAM_Database_Mgr

Thanks for that. I did go through the PDF manual I had, and also did a
search for signature - but that may have been my downfall. The place it
appears is in an image, not a text field.

As a side question (I'm expecting the answer to be no, but)... is it
possible to migrate from EDB back to DBISAM? (When the record contains
blobs). I'm just wondering if migrating away, and back again may be a
way of changing/removing signatures from my DBISAM tables?

Cheers

Adam.

Adam,

<< As a side question (I'm expecting the answer to be no, but)... is it
possible to migrate from EDB back to DBISAM? >>

Not without using something like reverse-engineering.  DBISAM is going to
have issues consuming BLOBs/memos in csv files, so that's a no-go.

<< I'm just wondering if migrating away, and back again may be a way of
changing/removing signatures from my DBISAM tables? >>

I'll see if I can work up a utility for this - I need to do it for EDB also,
especially for the encryption passwords.

Tim Young
Elevate Software
www.elevatesoft.com