Link to home
Avatar of DSM_22
DSM_22Flag for Canada

asked on

Transfer database from Pervasive SQL 2000i to PSQL v10 on a Server 2K3 Standard machine

I need to transfer a database from an old machine running pervasive sql 2000i to a new server running pervasive summit PSQL v10.  I'm unfamiliar with pervasive products, unsure of how to do this properly and have got the run around from pervasive for the last 2 days, so I've come to EE which is probably what I should have done in the first place.  Please help...

Avatar of Mirtheil
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
What kind of problems are you having?
Avatar of DSM_22


What kind of files should I be looking for? Is there a .ini or something within the pervasive folder that will tell me the location of the files I need to transfer? I'm very confused and have had little to no help from pervasive on this; I asked for some guidance and all I got was hot air :(
No.  THere isn't any list.  If the PSQL 2000i has a Database Name set up, you can look at that to get the directory where the data files are located but each application sets the data file names used.  For example, I have seen DB, DAT,BTR, MKD, and even files with no extensions.  You might check for DDF files (FILE.DDF, FIELD.DDF, and INDEX.DDF).  Those are used by the Pervasive engine for Relational access.  You might be able to find the data files from those.  
Data files can be located anywhere -- this is the power and flexibility that is the Pervasive database.  It is not up to the database engine, but rather the application to determine where to store things.  If your existing server is working, simply run the application, and it should start opening database files.  Then, start the Pervasive Monitor tool, connect to the server (if not already on it), and look at the Microkernel/Active Files screen.  The open files list will show you where the files are located.  For most applications, you must move ALL of the directory structure.  Typically, Btrieve files end in .DAT, .MKD, .BTR, or something of the like, but again, this is up to the app developer.  You really should check with the developer for more complete information.

While you're moving things, use the Pervasive Control Center (PCC) and connect to the server as well (if from a workstation).  Open up the server name, then databases, and see if there are any databases listed there that might pertain to your application.  (These will ONLY be there if the app uses the SQL portion of the database engine.)  If so, right-click on "Configuration" and select "Maintain Named Database".  Find the database name that was created.  This will ALSO have a directory path to some files.  If you DO find a named database, then you will need to ALSO create this database on the new server.  If not, then simply moving the files and pointing the application at the new location (usually by remapping a drive) is quite sufficient.
Avatar of DSM_22


Well I was able to locate the files thanks to the Monitor tool.  NOw, when I create a new database in PSQL 10, do I just browse to the folder I copied over (the one that contains the .DDF files?)? or is there another step I'm not following? This just seems to easy :)
Just browse to the folder you copied over when creating the database.