Pervasive.SQL as of yet does not support dual processors, but if you intend to use your server as more than just a database server, dual processors would allow the O/S to balance the load between the database engine and the O/S and other applications. Connecting to Pervasive SQL databases Connecting to Pastel Version 6.0 and Later Assuming Alchemex and Pastel are successfully installed and functioning on the workstation then you will need to create a Pervasive Database Name to reference your data files on either the local Machine (running a Workgroup or Workstation Engine) or on a Server.
Active5 years, 7 months ago
I've never touched PervasiveSql before and now I have a bunch of .ddf and .Btr files. I read that all I had to do was create a new database in the control center and point to the folder that contains these files.When I do this and look at the database there is nothing in it. Since I am new to Pervasive, I'm more than likely sure that I'm doing something wrong.
EDIT: Added a screen shot after running command prompt
To create a database name in the PCC, you need to connect to the engine then right click the engine name and select New then Database. Once you do that, the following dialog should be displayed:
Enter the database name, and path. The path being where the DDFs are located. In most cases the default options are sufficient.
A longer process is documented at http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=uguide/using.02.5.html.
If you pointed to a directory that had DDF files (FILE.DDF, FIELD.DDF,and INDEX.DDF) when you created the database name, you should see tables listed. If you pointed to a directory that does not have DDF files, the database will still be created but will have no tables defined. You'll either need to get DDFs from the vendor or create the table entries using CREATE TABLE (with IN DICTIONARY clauses) or use DDF BUilder to add table entries.
Based on your screen shot, you only have 10 records in FILE.DDF. This is not enough. There are minimum system tables required (X$FILE, X$FIELD, X$INDEX, and a few others). It appears your DDFs are not a valid set. Contact the client / vendor that provided the DDFs and ask for a set that include all of the table definitions.
Once you have tables listed in your Database Name, you can use ODBC to access the data.
Not the answer you're looking for? Browse other questions tagged pervasive-sql or ask your own question.
copy pervasive database files to a different machine
copy pervasive database files to a different machine
I am wanting to setup a lab environment so as to do some testing with a script i am writing that will do some updates to my existing pervasive database. I know i could setup a dummy database on exisiting server but i need to have the exact tables and data etc ... to work from. I will also be doing all this work from a totally different location or building . My question is can i make a copy of the existing database files and put them on my lab environment server and PCC will be able to open it and all the tables and data be intact ? or is there a better best practice solution to this problem ? If the copy would work what all files do i need to copy ? i am new to pervasive and am still a little confused about what all files are associated with the operation of the database. Thanks. Note: my existing DB name is HII if this helps in any replies that are offered.