Standard Databases

A standard database is a basic database file for single- or multi-user environments. Implementation of a database server is not required; however, there are limits on the amount of data and the number of simultaneous users. (If you prefer to use a more robust Oracle or SQL Server database, see Enterprise Databases.)

Creating a New Standard Database

To create a new standard database, choose File > New > Standard Database.

In the Database name field, specify the filename for the new *.rsr24 file. The path where the file will be saved is shown below this field; to change the location, click the browse icon in the field.

The following options are available when you create a new standard database:

  • Apply login security configures the new database to be login secure. You can then select the Open security window upon creation check box if you want to add user accounts as part of the database creation process. Note that you cannot automatically remove security from a database once it has been enabled. However, you can create a new non-secure database and use the Import from existing database check box to automatically import all of the data from the secure database to the non-secure one.
  • Import from existing database allows you to specify an existing database from which to import data when the new database is created. You can select to import projects, database settings, security-related information, restore points and more.

Opening an Existing Standard Database

If you have opened the file recently, choose File > Recent and then select the file in the Recent Databases list.

Otherwise, choose File > Open Database and then browse for the *.rsr24 file.

If the database has login security enabled and you are unable to connect, you will see a message stating that your account in the database is nonexistent, not active or not assigned to at least one security group. You will need assistance from someone who can create and update user accounts (see Managing User Accounts).

Upgrading a Standard Database from a Previous Version

Note: Starting in Version 2024, you can only open standard databases that were created in Version 11 or later.

If you have a standard database that was created in a previous version of the software, you can simply open it like any other standard database (File > Open Database). An upgraded copy will be created, with "_V24" appended to the filename. For example, if you open "MyDatabase.rsr20," the Version 2024 database that is created will be called "MyDatabase_V24.rsr24."

It is important to remember that upgrading a standard database will not automatically upgrade any library or template files that you may have been using in conjunction with that database, as these file types are stored separately. Please refer to the documentation on those files for information on upgrading them.

IMPORTANT: For best results, the standard database should NOT be open in the prior version. This ensures that all information in the database will be converted to the new database.

Using Data in an Earlier Version

You cannot save a standard database as an earlier version (e.g., you cannot save a *.rsr24 database as a *.rsr23 database). However, there are several ways that you can export the data in forms that can be used in earlier versions (with the caveat that functionality/data fields added in later versions will not be imported to earlier versions). These include:

Merging Databases

While merging databases is not supported per se, you can achieve a similar result by importing projects from one database into another.

Related Topics and Links