Hello

I use the following to create a new database, which I would like to migrate an old DBISAM 3 database into. Unfortunately, I am doing something wrong, and the migrator is never available in the drop-down list, and appears to be concealed from the database.

CREATE DATABASE "Client"
PATH 'C:\Clients\ClientEDB'
DESCRIPTION 'Client Database'

Then I create the module...

CREATE MODULE "migratedbisam3"
PATH 'C:\Clients\ClientEDB\edbmigratedbisam3.dll'
DESCRIPTION 'DBISAM3 Migrator'

Note the non-standard name of the module. I tried using the name of the dll, but that didn't work either.

This code displays the module correctly...

SELECT * FROM Configuration.Modules WHERE Name = 'migratedbisam3'

However, this does not do anything, error code #401...

MIGRATE DATABASE FROM "migratedbisam3" WITH DATA

...The migrator migratedbisam3 does not exist in the configuration EDBConfig

Then even the DROP statement fails, with a # 401.

I can't see the error of my ways, can you?

Regards & TIA

Peter

Peter


The only thing I can see is that you're missing the USING clause

Roy Lambert [Team Elevate]

Peter,

I don't see anything wrong in your code, but you could give this a try:

http://tinyurl.com/2uragxk

Regards Uli

Roy & Uli

I had to do one additional step, after creating the module...

CREATE MIGRATOR "DBISAM3Migrator"
MODULE "migratedbisam3"
DESCRIPTION 'DBISAM3 Migrator Module'

Then the statement...

MIGRATE DATABASE FROM "DBISAM3Migrator"
USING DatabaseDirectory = 'C:\Clients\ClientDatabase'
WITH DATA

...worked properly, and the migrator named DBISAM3Migrator appeared in the list of migrators in the EDBManager.

Thanks for your suggestions

Peter