 | What's New in Pervasive PSQL v10 (v10) |  |
|
This section discusses the additions and changes to Pervasive PSQL utilities.
The GUI utilities include a new one, DDF Builder, and changes to PCC, License Administrator, and License Generator.
DDF Builder is a Windows-based utility that allows you to view, create, and change Pervasive PSQL data dictionary files (DDFs) without modifying the underlying data file. The utility's primary purpose supports the following:
Note that DDF Builder is a specialized utility intended for advanced users and is not a utility that you would typically use daily.
DDF Builder is included as part of the complete installation and is an option under the custom installation.
For details, including tutorials, refer to the DDF Builder documentation that is accessed from the utility.
DDF Builder provides functionality with which you check the consistency of a table. A consistency check uses a set of validation rules to compare the physical data file against its metadata (the table against the data dictionary files). See Check Table Consistency in DDF Builder User's Guide.
PCC provides enhanced functionality to its Index Editor and New Database wizard, wizards to export data and import data, and user assignments to groups.
The Index Editor in PCC now supports creating partial indexes. The editor also now uses the unique option instead of allow duplicates.
See To create a unique index and To create a partial index in Pervasive PSQL User's Guide, and PARTIAL in SQL Engine Reference.
The New Database wizard contains options to specify V1 metadata or V2 metadata. The default is V1 metadata. See Metadata Versions .
The Export Data wizard exports data from a table to a text file. This wizard has been streamlined from its previous version and provides a more efficient interface.
The Import Data wizard reads delimited data from a text file and adds the data to a table. This wizard is new in Pervasive PSQL v10.
Both wizard are accessed by right-clicking on a table name in Pervasive PSQL Explorer.
See Exporting Data with Export Data Wizard and Importing Data with Import Data Wizard and Pervasive PSQL User's Guide.
Existing users can now be added to a group. In previous releases, a user could be added to a group only when creating the new user. See To assign a user to a group using Pervasive PSQL Explorer in Pervasive PSQL User's Guide.
License Administrator now accepts and displays license keys specific to platforms. Such keys restrict the use of the database engine to an operating system(s) and the bit architecture of the operating system(s).
For example, if your license key has a platform of "Win64," you can apply that license to a database engine running only on a Windows 64-bit platform. The license is invalid for Windows 32-bit platforms. Other types of platform keys permit product use on all operating systems supported by Pervasive PSQL.
See License Key Platform in Pervasive PSQL User's Guide.
The License Generator utility now supports license generation for specific platforms that includes the bit architecture of the platform (the licenses are referred to as platform specific license keys). See License Key Platform in Pervasive PSQL User's Guide.
Note that License Generator is available only to Pervasive Software Original Equipment Manufacture (OEM) Partners.
The CLI utilities include new utilities pvmdconv and psc, and changes to pvddl.
This utility provides functionality to convert V1 metadata to V2 metadata.
See Metadata Versions and pvmdconv in Pervasive PSQL User's Guide.
The psc utility replaces the btisc utility. Psc retrieves and sets control information about Pervasive PSQL services. Note that, on Windows Vista, you must have administrative privileges to run psc.
See psc in Pervasive PSQL User's Guide.
Pvddl, which is used to execute a series of SQL statements in a command file, has two new options. One option allows you to specify the character separator to use between SQL statements in the command file. The other option allows you to log output to a file instead of to standard output (stdout).
See pvddl in Pervasive PSQL User's Guide.
|
Chapter contents
Prev topic: Relational Interface Support
|