I want to take a database directory that contains a catalogue and
tables and everything, and copy it as-is to another computer for use.
I've copied the files, and then run the ElevateDB Manager, and created
a session pointing to the folder, but none of the tables are present.
What did I miss out? The file location is exactly the same, so that
shouldn't be a problem. It knows the name of the database, and had that
without me doing anything more.

--

Matthew Jones

Matthew

>I want to take a database directory that contains a catalogue and
>tables and everything, and copy it as-is to another computer for use.
>I've copied the files, and then run the ElevateDB Manager, and created
>a session pointing to the folder, but none of the tables are present.
>What did I miss out? The file location is exactly the same, so that
>shouldn't be a problem. It knows the name of the database, and had that
>without me doing anything more.

I've had this, but can't remember exactly what is was, and all my machines are busy just now.

Try checking that the database is pointing to the right directory.

Roy Lambert

Roy Lambert wrote:

> Try checking that the database is pointing to the right directory.

Aaargh! I knew that this was right as I hadn't changed anything, but
you asking made my mind clunk and realise I had renamed the project.
Amazing how the mind works... (Or doesn't!)  Quick change, now working.
Thanks.

--

Matthew Jones

Matthew


Just a thought - you did copy the configuration file as well as the tables and catalog.


Roy Lambert

Matthew Jones wrote:

> > Try checking that the database is pointing to the right directory.
>
> Aaargh! I knew that this was right as I hadn't changed anything, but
> you asking made my mind clunk and realise I had renamed the project.
> Amazing how the mind works... (Or doesn't!)  Quick change, now
> working.

It would be nice to have something about this in the FAQ. Just did the
same thing again today, and having something that describes the simple
process of moving a database would be good. Indeed, what I'd really
like is some sort of "open a session" too, to pick up the session
details from the directory, but that may be harder. Anyway, at least I
could find this and realise the problem again.

--

Matthew Jones

Matthew,

<< I want to take a database directory that contains a catalogue and tables and everything, and copy it as-is to another computer for use.  I've copied the files, and then run the ElevateDB Manager, and created a session pointing to the folder, but none of the tables are present. What did I miss out? The file location is exactly the same, so that shouldn't be a problem. It knows the name of the database, and had that without me doing anything more. >>

Normally, the process should be this:

1) Backup the database on the source machine.

2) Create the database definition on the target machine using the CREATE DATABASE DDL statement.  The configuration file will be created automatically when you first open the session in the location specified by the configuration path defined for the engine/session (TEDBEngine.ConfigPath/TEDBSessionLocalConfigPath when TEDBEngine.UseLocalSessionEngineSettings=True).

3) Restore the database on the target machine.

Tim Young
Elevate Software
www.elevatesoft.com

Matthew,

Forgot:  when backing up/restoring the database, make sure that the "Include Catalog" is specified (or selected in the EDB Manager).

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Normally, the process should be this:
>
> 1) Backup the database on the source machine.
>
> 2) Create the database definition on the target machine using the
> CREATE DATABASE DDL statement.  The configuration file will be
> created automatically when you first open the session in the location
> specified by the configuration path defined for the engine/session
> (TEDBEngine.ConfigPath/TEDBSessionLocalConfigPath when
> TEDBEngine.UseLocalSessionEngineSettings=True).
>
> 3) Restore the database on the target machine.

I shall have to practice this.

--

Matthew Jones

Tim


Don't you still have to set the database path?

Roy Lambert

Roy,

That's step 2) : "Create the database definition..."

--
Fernando Dias
[Team Elevate]