Can V11 access a V8 database?

C

Carol

New Member
I have a customer who has a V8.2 database. They are migrating to V11 (finally!) and I need to do a dump/load of the current database to move it to V11. The problem is that the PC I have V8 running on just went on the fritz. Their install doesn't have a developer version. My question is can I access the V8 database with V11 in order to just dump out their current data?
 
Hi Carol

Take a look in your DLC\bin folder, you may have an 83dbutils folder - this will do the trick! I have this in 10.2 don't have an 11 to look at right now.

Thanks

Chris
 
That directory is in $DLC/bin in 11.x as well. Read the readme file in that directory for more information. Follow the instructions to back up and convert it, then dump and load with 11. Be sure to work on a copy of the DB, not the original, in case you run into issues. You need a backout plan. It wouldn't hurt to take an OS backup of the DB (offline, of course) in addition to the 83_dbutil probackup.
 
You likely can't access the v8 DB directly with a v11 client. The rule of thumb, typically, is that you can make client/server connections when the client is one major version ahead of the server. Shared memory connections are out of the question when client and server are on different versions.
 
11.x contains older version convxy tools which should be able to upgrade the database to the current version.

%dlc%\bin\91dbutils\91conv89.bat

followed by

%dlc%\bin\101dbuitls\101a_dbutil.exe <databasename> -C conv910

followed by

%dlc%\bin\dbutil <databasename> -C conv1011

I vaguely recall that the before image file must be truncated before you can use dbutil -C convxy - so you will need to do that first using the V8 install.
 
Do you just need to dump the data?

Or do you also need the .df?

If you only need the data then a binary dump can be performed without a development license.

IMHO using the bin/*utils is a level of pain and suffering that should be avoided whenever possible. Especially on Windows. Yes, they exist. Yes they work. Sometimes. After hours of hair pulling and tracking down obscure environment settings and config files. If you are that patient. And lucky. Far better to avoid the need in the first place.

You might also be surprised at which utilities work on a runtime license if you start a session with -rx.
 
I've never used it, but it seems to me I heard that binary dump was somewhat sketchy in the v8 time frame. For those who have used it, was it reliable?
 
I found the reference I was thinking of. From Scott Dulecki's Dump & Load book (pg. 37):

The binary dump option was introduced as an option on proutil in Progress 8.2, and is the fastest individual dump option.
<snip>
There are numerous bugs with the binary load below Progress 8.3C, so if you're at that level, you should not consider a binary dump and load.
Click to expand...
 
There were /some/ bugs back in the day. (Mostly having to do with field rpos as I ever so dimly recall.)

But I used it quite successfully way back when.

The v6 era undocumented binary d&l -- now that was something exciting to use. There was good reason for it to be undocumented :)
 
I don't necessarily NEED to do a 'convert'; if a dump&load is possible, I'm fine with that. I just need a way to get their current V8 data into a V11 database and my V8 developer environment is down right now.
 
First try accessing the dictionary using -rx on the startup command. You might be able to dump the .df and the data that way.

If that doesn't work I would try to go the binary dump route.

If that fails I would work really hard to get my v8 dev environment running again.
 
You must log in or register to reply here.
Back
Top