How to open a Progress .bup file

progress-databaserestore

I have a .bup file which is supposed to be a Progress database file.
My question is, how can I open/restore it and look at the data?

Best Answer

You need to have Progress installed. In it you will find a command: prorest run from command line that will help you restore a previously backed up database. At least if it has been backed up using the built in back up command (probkup).

To make things easier for yourself you could start the Progress command line environment (it should be in the bin directory in your installation path). Simply run proenv to start that and then follow the steps below. If on Windows you will most likely find proenv in your Start menu.

Basic syntax:

prorest [new database] [archive]

so for example

prorest c:\temp\mynewdatabase file.bup

After that you can connect to the database using Progress built in commands. You might find more help at: Progress KnowledgeBase and Progress communities.

A specific description of the prorest command can be found here: Progress KnowledgeBase Article 99033

Related Solutions

Export pipe-delimited data with progress db

If you're ok with writing some code:

OUTPUT TO VALUE("filename.d"). 

FOR EACH table-name:
EXPORT DELIMITER "|" table-name.
END.

OUTPUT CLOSE.

It's possible to write something that's more automated than this if you're interested.

SQL Server – Recover from .bak File with NOINIT

That's because by not specifying the FILE parameter of RESTORE DATABASE, it is defaulting to 1 which will be the 1st backup set on that media. See the section on this page of Specifying a Backup Set.

Instead of:

restore database YourDb
from disk = 'C:\yourpath\backupfile.bak';
go

You will want to do:

restore database YourDb
from disk = 'C:\yourpath\backupfile.bak'
with file = <n>;
go

Where N is the backup set number in the media. N can be obtained from running RESTORE HEADERONLY on the media. The column you will be concerned with is Position to use with the FILE option.

Best Answer

Related Solutions

Export pipe-delimited data with progress db

SQL Server – Recover from .bak File with NOINIT

Related Question