Tim

If I create (migrate) a database in (say) C:\trial how do I move it to E:\TfR?

Roy Lambert

Tim


Just re-read what I'd posted and realised it could easily be mistaken.

I migrated a database from a live DBISAM system to C:\Zap\Trial under ElevateDB and then thought what if I don't want it there but want to physically locate it somewhere else - is this a simple copy or what?

Roy Lambert

Roy,

<< If I create (migrate) a database in (say) C:\trial how do I move it to
E:\TfR? >>

It's a three-step process:

1) Move the database directory contents to e:\tfr, being sure to include the
database catalog "edbdatabase.edbcat".

2) Drop the existing database using the DROP DATABASE SQL statement.   DO
NOT do this step without doing the first step or you'll simply just delete
the entire database and have no backup copy.

3) Create the same database name with the new path using the CREATE DATABASE
SQL statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


A bit messier than just a straight file copy but it looks easy enough

Roy Lambert

Roy,

<< A bit messier than just a straight file copy but it looks easy enough >>

Yeah, but it buys not having to ever use a directory path name anywhere in
your application SQL or code, which makes the code completely portable by
only needing to change the database path definition itself via CREATE
DATABASE.  It's essentially the same as DBISAM C/S, but in local and C/S.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Yeah, but it buys not having to ever use a directory path name anywhere in
>your application SQL or code, which makes the code completely portable by
>only needing to change the database path definition itself via CREATE
>DATABASE. It's essentially the same as DBISAM C/S, but in local and C/S.

Nifty and I can see some advantages to it.

Roy Lambert