For some reason the migrators that are already installed in my config file are pointing to the wrong location

eg C:\Program Files\ElevateDB 2 ADD\libs\edbmigratebde\unicode\win32\edbmigratebde.dll

and I cannot migrate without an error

They need to be as follows

eg C:\Program Files (x86)\ElevateDB 2 ADD\libs\edbmigratebde\unicode\win32\edbmigratebde.dll

which is where they are installed when  I create a new config file

How do I get delete of the wrong ones and replace with the good ones eg If I run the following

DROP MODULE "edbmigratebde"  I get the following error

ElevateDB Error #201 The module edbmigratebde in the configuration EDBConfig cannot be dropped because it is still referenced by the migrator BDE in the configuration EDBConfig

Thanks

Drop the migrator first: DROP MIGRATOR "BDE"

Charles Bainbridge wrote:

Drop the migrator first: DROP MIGRATOR "BDE"


OK That works for the bde  and ado migrators but when I try to do the others eg DROP MIGRATOR "dbisam1" I get

ElevateDB Error #401 The migrator dbisam1 does not exist in the configuration EDBConfig

Do you (or anyone) know the correct syntax for the other migrators

Thanks

Michael Saunders wrote:

<< Do you (or anyone) know the correct syntax for the other migrators >>

Check what modules and migrators you have installed by querying the configuration. Then you can drop the ones that exist.

select * from configuration.migrators
AND
select * from configuration.modules

<< Check what modules and migrators you have installed by querying the configuration. Then you can drop the ones that exist. >>

In addition to this good tip, you can also use a quick link in the EDB Manager to find out what modules are present via a Session node's task links:

"View Installed Modules"

Tim Young
Elevate Software
www.elevatesoft.com