BTRIEVE to SQL

[cjt]

this guide walks through the migration from BTRIEVE type databases to Pervasive SQL.

http://www.themajorbbs.com/bbs/viewtopi ... 7891cfd6b4

Has anyone done it recently that can provide a more recent writeup? The links are broken and I'm not sure exactly what software package needed.

[mirtheil]

this guide walks through the migration from BTRIEVE type databases to Pervasive SQL.

http://www.themajorbbs.com/bbs/viewtopi ... 7891cfd6b4

Has anyone done it recently that can provide a more recent writeup? The links are broken and I'm not sure exactly what software package needed.

Technically, there is no conversion needed when moving from Btrieve to Pervasive SQL. Pervasive SQL is just a newer version of Btrieve and still includes the Btrieve interface although it has been downplayed.

If, however, you are using Btrieve data files in v5.x (or older) format, the newer (v9 and later) engines will not write to those files. You'll get an error 46 (access denied). Rebuilding the files using the Pervasive rebuild tool will resolve that.

If you have specific questions about Btrieve to Pervasive SQL changes, please post them and I'll try to answer them. Include the version you are using and the version you want to use.

[cjt]

is there any benefit in going from btrieve over to sql? Like, less risk of access violations?

[ODSBBS]

I've always been afraid to try this... possibly from my own lack of knowledge... but what if you convert your files to the new format, and you suffer corruption down the road... and need to reindex the dat files?

Will worldgroups reindex utility which automatically runs when it needs to, suddenly cause more problems since you never changed that program to use the new format? (or majormuds reindex utility for that matter) So the program just tries to rebuild the dat files as it expects to, and you need them converted to the new format?

So you go from one problem, to a huge problem instantly with dat files completely not usable now? And possibly more corrupt now?

[Lochlenn]

i actually just did this myself, but i used psql 10. Directions were just that easy. And it worked. So far everything runs smoother, loading time is MUCH faster. Thinking of increasing polling rate some. Im going to do a reindex on all datafiles, but since the board loads, i dont see it being a problem.

[Lochlenn]

i actually just did this myself, but i used psql 10. Directions were just that easy. And it worked. So far everything runs smoother, loading time is MUCH faster. Thinking of increasing polling rate some. Im going to do a reindex on all datafiles, but since the board loads, i dont see it being a problem.

ok, using the offline reindex cause it to replace all the files with empties, loaded up the board to an empty class file error. just replaced them with the converted dats and it fired right back up

[ODSBBS]

ok, using the offline reindex cause it to replace all the files with empties, loaded up the board to an empty class file error. just replaced them with the converted dats and it fired right back up

So everytime you do an offline recovery... which would also be the same as a "sys reset" in the game which you use constantly to fix most minor errors and monster regen problems... it blanks the dat files? so you end up having to copy over the same ones with the problem that need to be fixed??? this does not sound good lol.

[Lochlenn]

ok, using the offline reindex cause it to replace all the files with empties, loaded up the board to an empty class file error. just replaced them with the converted dats and it fired right back up

So everytime you do an offline recovery... which would also be the same as a "sys reset" in the game which you use constantly to fix most minor errors and monster regen problems... it blanks the dat files? so you end up having to copy over the same ones with the problem that need to be fixed??? this does not sound good lol.

no, just wg data files, mud files are fine. as long as wg doesnt run a reindex, nothing happens. It runs MUCH faster, at least it seems to me, and it gives the ability to add info from your datafile to anything like a website or stats page (no idea how to do this but if anyone knows, id take the info).

[zlarb]

It's definitely faster