Database Contents

[JonMeecham]

We've just got a new customer and our job is to replace another Progress application with our own.

We have a copy of the database and are trying to work out what we can extract for history records and product definitions etc for our application.

The business relationship is not good between our customer and their previous supplier so we can't count on their help really.

The problem is that the database uses _user records to restrict data functions (we cant dump see database structure and cant dump a df etc.)

We need to be able to see the structure so we can do this.

Any ideas how we can "break" the _user password protection or force the database open so we can view stuff in the data dictionary?

Cheers

Jon

 

[richard_thorp]

Nope.

Have you tried connecting ODBC? Convert it to V9, set up SQL-92 access - you just might be able to get the data out that way.

Another option - does the application create reports? Does it put those reports to disk, either as CSV files or spool files? If so, use them!

If not, it's back to the original supplier. Even though the relationship has deteriorated, I'm sure they'll accept a few $$$ to perform an extract.

We've just got a new customer and our job is to replace another Progress application with our own.

We have a copy of the database and are trying to work out what we can extract for history records and product definitions etc for our application.

The business relationship is not good between our customer and their previous supplier so we can't count on their help really.

The problem is that the database uses _user records to restrict data functions (we cant dump see database structure and cant dump a df etc.)

We need to be able to see the structure so we can do this.

Any ideas how we can "break" the _user password protection or force the database open so we can view stuff in the data dictionary?

Cheers

Jon