Skip to content

Converting to Pervasive.SQL

Database Builder provides a tool for converting tables into a Pervasive.SQL database from any other supported database type. This tool will convert the table structures from the current workspace's database into a Pervasive.SQL database, then move all of the data.

To convert tables from the current workspace's database into a Pervasive.SQL database, select Convert to Pervasive.SQL from the Database menu. This activates the Table Selection Dialog.

Select the tables that you wish to convert, then click the Convert button. This activates the Convert to Pervasive.SQL dialog. Enter the following selections:

Server

Enter the server name, or host, where the PSQL database is located.

Database

Enter the name of the database that needs to be accessed.

User

Enter the user name to use for authentication when you log on to the PSQL database.

Password

Enter the password for your user name.

URI

URI (Uniform Resource Indicator) is used to specify in what Pervasive.SQL server and database the table is located. The format of a URI is:

btrv://psquser@PervasiveServer/DatabaseName?pwd=***

The URI will be generated to reflect the typed server, database, user, and password.

Delete Original After Conversion

Select this option if you would like to delete the original tables after successful conversion. If any errors occur during conversion, the original tables will not be removed regardless of the selection you make here.

Recnum Support

Select this option if you need the converted tables to keep the same recnum values as the original tables.

Owner

Owner Name

This is used to restrict access to the tables. If a table is converted using an owner name, applications will have to pass the owner name in order to have full access to the table.

Read Only Access

If this option is checked, the application that does not pass the correct owner name will have read-only access to the tables. This option is only available if an owner name is set.

Encrypt Data

If this option is checked, the data in the tables will be encrypted using the owner name specified. Applications that do not pass the correct owner name will not be able to read the data stored in the tables. This option is only available if an owner name is set.

See Also