I am trying to migrate DBISAM 4 tables to a new Elevate DB database using the EDB Manager. I do not have any migrate options to select in the migrator drop down box of the utility. I tried to compile the migrator, which gave me CONST errors. I am using 2.06 build 2.  I also reinstalled the utilities.

I have Delphi 7 and Delphi XE installed on my machine. In this case I am wanting it use convert the tables from DBISAM to EDB for use with Delphi 7.

Any help is appreciated.

John

John,

Did you create the migrators?

I haven't migrated for a while but as i recall these steps did work last time i used them :

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=rsdelphiwin32&version=XE2&topic=migrating_dbisam_database_mgr

(or short link in case one above gets broken : http://bit.ly/tRWEFF)

Raul

<<

John Postnikoff wrote:


I am trying to migrate DBISAM 4 tables to a new Elevate DB database using the EDB Manager. I do not have any migrate options to select in the migrator drop down box of the utility. I tried to compile the migrator, which gave me CONST errors. I am using 2.06 build 2.  I also reinstalled the utilities.

I have Delphi 7 and Delphi XE installed on my machine. In this case I am wanting it use convert the tables from DBISAM to EDB for use with Delphi 7.

Any help is appreciated.

John
>>

John


I did my migrations so long ago and things have changed. However, I just had a look in EDBManager and when I select a session I can see "Create Database Migrators" at the bottom of the tasks box. Have you tried clicking that?

Roy Lambert

I did find and did "Create Database Migrators" however DBISAM 4 is not in the list there is ADO, BDE, DBISAM 1-2-3 and Nexus DB in the list but not DBISAM 4. I did try to remove and re-install.

John



Roy Lambert wrote:

John


I did my migrations so long ago and things have changed. However, I just had a look in EDBManager and when I select a session I can see "Create Database Migrators" at the bottom of the tasks box. Have you tried clicking that?

Roy Lambert

John


I get

ADO
BDE
DBISAM1
DBISAM2
DBISAM3
DBISAM4
NexusDB

That's in 2.05b11

Roy Lambert

When I first tried to create the DBISAM 4 migrator I used the SQL Window in the DB Manager and not off the menu to create migrators.

I later noticed in the table showing all the migrator paths that the DBISAM4 path was not correct (I used the statement from the docs), which the path was c:\ElevateDB... instead it should have been under c:\Progam Files\ElevateDB.... (not sure how one can edit this table that shows the paths of the migrators).  

When I tried to re-create the migrators off the menu in the dbmanager it would not fix or recreate the DBISAM 4 migrator from path that was first created from my SQL statement. So in the end, I removed all the config files and installed again.  It then showed all the migrators and worked very well.

John Postnikoff


Roy Lambert wrote:

John


I get

ADO
BDE
DBISAM1
DBISAM2
DBISAM3
DBISAM4
NexusDB

That's in 2.05b11

Roy Lambert

John

>When I first tried to create the DBISAM 4 migrator I used the SQL Window in the DB Manager and not off the menu to create migrators.
>
>I later noticed in the table showing all the migrator paths that the DBISAM4 path was not correct (I used the statement from the docs), which the path was c:\ElevateDB... instead it should have been under c:\Progam Files\ElevateDB.... (not sure how one can edit this table that shows the paths of the migrators).

You can only do that using the supplied utilities - DROP, ALTER etc but can't edit it directly

Roy Lambert [Team Elevate]

John,

<< I later noticed in the table showing all the migrator paths that the
DBISAM4 path was not correct (I used the statement from the docs), which the
path was c:\ElevateDB... instead it should have been under c:\Progam
Files\ElevateDB.... (not sure how one can edit this table that shows the
paths of the migrators). >>

In the future you can use the ALTER MODULE statement to alter the path to a
migrator module (DLL):

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ALTER_MODULE

It will save you from having to delete the configuration file and go through
all of that work.

--
Tim Young
Elevate Software
www.elevatesoft.com