Loading multivolume db

B

balaji.n

New Member
Hello,

I'm using dump and load utilitiy to migrate from V7 to V9.
I've dumped the data and created a void V9 multi-volume database.
But I'm not sure how to load the definitions and data into that void database from the dump. When I tried to start the server , it throws the error message -613 ( meaning empty database) and If I tried to connect to the database ( via database-> connect ) , it says cannot open void database...

Is it possible to load the dump ( definitions and data) using PROCOPY utility.. ? I'm stuck at loading the data into multi-volume database ??

When we use dump and load technique, can't we create multi-volume database ?

FYI, I tried to create normal database using ( Database -> create ) utility
and was able to load the data successfully into that database. But If I start the database in multi-user mode, it fails ( Not able to start in multiuser mode)
So I created database using prostrct.

Any help would be greatly appreciated......

Thanks in advance.
 
After you have created the database with prostrct (create) youshouldalso use procopy and copy "empty.db" (which resides inyourProgressinstall directory) into the new database. After that youshouldbe able to access the database via the database administrationtools (i.e. load the df etc) and start db servers.

HTH
 
Awesome...worked great !!

empty.db might be a trivial information for Progress gurus,but a very helpful information to me since I struggled starting up the V9 database with dump and load..

Thanks ...
 
I've one more question on the same issue..

Currently I've loaded some test data and things look OK.. During implementation, I need to load the real production data ( dump and load)..- from V7 to V9

I've already created V9 database ( including table df) in the new server..I just need to replace the data in new server with production server data during implementation.. I was just thinking if there is a way to clear the table contents in new server and load just the table contents file from the production , it would be easier..
Otherwise, I need to go through the entire step of
> refreshing the database with empty.db ( or re-create new v9 void db)
> reloading definitions files
> reloading data cotnents..

Any ideas... Thanks in advance..
 
Creating the empty database from scratch does not take that long doesit? Generally loading the actual data is what eats up most time...
 
You must log in or register to reply here.
Back
Top