During the migration of DBISAM3 database, the migrator keeps popping dialogs asking to enter the password when migrating encrypted tables.  How
to provide the password to the migrator by code to prevent it from showing those dialogs?

Adulaziz,

<< During the migration of DBISAM3 database, the migrator keeps popping
dialogs asking to enter the password when migrating encrypted tables.  How
to provide the password to the migrator by code to prevent it from showing
those dialogs? >>

Are you using the migration facilities in code, or via the EDB Manager ?
The password is a parameter called TablePasswords, which you can see by
using this SQL statement on the Configuration database:

SELECT * FROM MigratorParams

http://www.elevatesoft.com/edb1sql_migratorparams_table.htm

http://www.elevatesoft.com/edb1d7_querying_configuration_objects.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Are you using the migration facilities in code, or via the EDB Manager ?>>

I am doing this by code through the application level.  I will try to check the links tomorrow.  It is very late here.

Tim,

This is my code.  How to pass the password of the DBISAM3 table to the migrator using this code?

EDBSession1.Execute('CREATE MIGRATOR "DBISAM3" MODULE "edbmigratedbisam3" TablePasswords saw3132');
EDBDatabase1.Database     := 'MyDatabase';
EDBDatabase1.DatabaseName := 'MyDatabase';
EDBDatabase1.Open;
EDBDatabase1.Execute(Format('MIGRATE DATABASE FROM "DBISAM3" USING DatabaseDirectory = %s WITH DATA',[QuotedStr(sDirectory)]));
EDBDatabase1.Execute('DROP MIGRATOR "DBISAM3"');
EDBDatabase1.Close;

Tim,

Please ignore my previous post.  This is the code that I am using.

EDBSession1.Execute('CREATE MIGRATOR "DBISAM3" MODULE "edbmigratedbisam3"');
EDBDatabase1.Database         := 'MyDatabase';
EDBDatabase1.DatabaseName := 'MyDatabase';
EDBDatabase1.Open;
EDBDatabase1.Execute(Format('MIGRATE DATABASE FROM "DBISAM3" USING DatabaseDirectory = %s WITH DATA',[QuotedStr(sDirectory)]));
EDBDatabase1.Execute('DROP MIGRATOR "DBISAM3"');
EDBDatabase1.Close;

Abdulaziz,

Use this instead:

EDBDatabase1.Execute(Format('MIGRATE DATABASE FROM "DBISAM3" '+
'USING DatabaseDirectory = ''%s'', '+
'TablePasswords = ''%s'' '+
'WITH DATA',[QuotedStr(sDirectory,sTablePassword)]));

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,


<<Use this instead:

EDBDatabase1.Execute(Format('MIGRATE DATABASE FROM "DBISAM3" '+
'USING DatabaseDirectory = ''%s'', '+
'TablePasswords = ''%s'' '+
'WITH DATA',[QuotedStr(sDirectory,sTablePassword)]));>>


I got AV error!!!  Any suggestions?

Tim,

This is the excat statment that I am using:

MIGRATE DATABASE FROM "DBISAM3" USING DatabaseDirectory = 'E:\Sawami Projects\FullAccount v 5.x\Database', TablePasswords = xxxx WITH
DATA

Abdulaziz,

<< This is the excat statment that I am using:

MIGRATE DATABASE FROM "DBISAM3" USING DatabaseDirectory = 'E:\Sawami
Projects\FullAccount v 5.x\Database', TablePasswords = xxxx WITH DATA >>

Are you enclosing the TablePasswords parameter value in single quotes, or
not ?

If not, then it is a bug, but you must enclose string parameters in quotes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Are you enclosing the TablePasswords parameter value in single quotes, or
not ?

If not, then it is a bug, but you must enclose string parameters in quotes.>>


That solves the problem.  Thanks...