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 *.rsr20 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 imports entire projects and other data from an existing database, after the new database is created.
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 *.rsr20 file.
If the database has login security enabled and you are unable to connect, you may be encountering one of the following issues:
No access to the database. If you have not been given access to the database, you will see a message stating that your account in the database is 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).
Windows authentication failed. If your Windows login (domain and username) is different from what was specified for your user account, you will see a message to connect using alternative credentials. You will need assistance from someone who can enable the use of alternative credentials for your user account.
Upgrading a Standard Repository from a Previous Version
If you have a standard repository 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 "_V20" appended to the filename. For example, if you open "MyDatabase.rsr10," the Version 2020 database that is created will be called "MyDatabase_V20.rsr20."
It is important to remember that upgrading a standard repository 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 repository should NOT be open in the prior version. This ensures that all information in the repository will be converted to the new database.