copyng a database problem

[jesusprovidenci]

I have a new server and i need to migrate may data base from the old server to new one.

Y try to copy te data base whit this line
sinze new server

procopy \\old_server\dbname d:\directory\bdname

and it show me:

imposible to open or found this file: d:\directory\bdname.d1 error = 2 (43)
\\old_server\dbname is a copy of d:\directory\bdname the bd can´t be open

 

[RealHeavyDude]

You don't say anything 'bout the Progress/OpenEdge version you are using - so I assume that you're at least using Progress V9:

The file with the .db extension mostly contains the structure description of your database in binary form. It contains the full path to each file that belongs to your database - and in your case this path includes the d: drive letter which is not accessible from a remote system. Therefore you will not succeed with procopy copying the database from a share.

Option 1: Copy the files with an OS copy

When you have all database files available in your destination folder you can correct the .st file. This is the representation in ASCII form which you can you to update or even rebuild the .db file using the prostrct utility ( prostrct repair and builddb respectively ). If the database files are spread over different folders it's more work and it will only succeed if you copy ALL files correctly.

Option 2: Use backup / restore

Make a ( Progress ) backup of the database on your old machine, copy the backup and the .st file over to your new machine, eventually create a void database with the .st file ( make sure the database block size of the back and the void database do match ) and restore the backup over that void database.

HTH, RealHeavyDude.

 

[jesusprovidenci]

Ok , Tanks.

You don't say anything 'bout the Progress/OpenEdge version you are using - so I assume that you're at least using Progress V9:

The file with the .db extension mostly contains the structure description of your database in binary form. It contains the full path to each file that belongs to your database - and in your case this path includes the d: drive letter which is not accessible from a remote system. Therefore you will not succeed with procopy copying the database from a share.

Option 1: Copy the files with an OS copy

When you have all database files available in your destination folder you can correct the .st file. This is the representation in ASCII form which you can you to update or even rebuild the .db file using the prostrct utility ( prostrct repair and builddb respectively ). If the database files are spread over different folders it's more work and it will only succeed if you copy ALL files correctly.

Option 2: Use backup / restore

Make a ( Progress ) backup of the database on your old machine, copy the backup and the .st file over to your new machine, eventually create a void database with the .st file ( make sure the database block size of the back and the void database do match ) and restore the backup over that void database.

HTH, RealHeavyDude.