Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Mirating From DBISAM3
Tue, Feb 17 2015 11:30 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Hi,

I am attempting to migrate a DBISAM3 database to EDB.  It is something that I have done in the past but I am lost in trying to do it this time.

SELECT * FROM Configuration.modules shows that edbmigratedbisam1, edbmigratedbisam2 and edbmigratedbisam3 are defined (but not edbmigratedbisam4).

SELECT * FROM Configuration.migratorparams to show the parameters results in an empty result set.

What ParamName do I need to migrate my DBISAM3 database?  Is there anything else I need to do?

MIGRATE DATABASE FROM "DBISAM3"
  USING <ParamName> = <ParamValue>
WITH DATA

I do not know why DBISAM4 migrator does not exist.  Executing the following

CREATE MIGRATOR "DBISAM4" MODULE "edbmigratedbisam4" DESCRIPTION 'DBISAM 4 Migrator' results in the message

ElevateDB Error #401 The module edbmigratedbisam4 does not exist in the configuration EDBConfig.

Many thanks.


Richard
Wed, Feb 18 2015 1:53 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Richard


Operating off vague memory, and assuming you're doing it in EDBManager then you're ready to go since you have the DBISAM3 migrator installed and you want to migrate DBISAM3.

You need to create the database (ie tell EDBManager what directory to use) open that database and click on Migrate Database (near the bottom). That should bring up a form where you can select which migrator to use and set the parameters.

Then its just click'n'go

Roy Lambert
Wed, Feb 18 2015 3:18 AMPermanent Link

Malcolm Taylor

In addition to Roy's info, you should be able to create all the default
migrators, including DBISAM4 if that is what you really need, as
follows:

1.  Launch Elevate DB Manager
2.  Select the Session to contain the migrated database
3.  From the Session Properties panel, click "Create Database Managers"

The above gives me 8 migrators, including DBISAM4
Wed, Feb 18 2015 3:25 AMPermanent Link

Malcolm Taylor

> 3.  From the Session Properties panel, click "Create Database
> Managers"

oops!  
Create Database Migrators
Wed, Feb 18 2015 4:33 AMPermanent Link

Richard Harding

Wise Nutrition Coaching

Thank you Roy and Malcolm,

I created a new session with a new configuration file and everything worked exactly how you both indicated.

The migrators are not behaving properly in the Default session which is a nuisance but not a big deal since I have been able to migrate the database.

Many thanks
It makes such a difference to have this kind of support with other members of Tim's community.

Richard
Image