Bosch Appliances D5500CU manual Integrate the RPS Database Files into the SQL Database

Page 47

RPSUpgrade RPS en 47

4.4

Integrate the RPS Database Files into the SQL Database

4.4.1

Automatic Integration

 

In Versions 5.11 and lower, RPS uses a network drive to share database files (.dat files)

 

among all of the RPS computers. In Versions 5.12 and later, RPS integrates the .dat files into

 

the SQL database. The SQL database is then installed locally on the same computer that RPS

 

is installed on, or it is installed on a network that all of the RPS computers can access.

 

During a new installation of RPS 5.12 or later, or when upgrading to RPS 5.12 or later, the

 

RPS .dat files are automatically integrated into the SQL database.

4.4.2

Manual Integration

 

If the integration of the RPS .dat files into the SQL database fails (for example, a network

 

failure occurs), then the RPS .dat files must be manually integrated into the SQL database.

 

To manually integrate the RPS .dat files into the SQL database:

 

1.

Start RPS.

 

2.

Select Config>System>File Locations.

 

 

The File Locations tab opens.

3.Click Upgrade Database.

All existing RPS .dat files are copied from their current location to the new SQL database location.

Bosch Security Systems, Inc.

Installation Guide

4998141259 12 2011.10

Image 47
Contents RPS Page Table of Contents Index MaintenanceLog into RPS RPS Operation and Control Panel Account NotesSoftware License Agreement 1Legal1Trademarks En Legal RPS RPS Minimum System Requirements IntroductionRelease Notes Browser Minimum System Requirements for SQL Express OnlyMinimum 500 MHz PC with Vista RPS and SQL Express on the Same PC Minimum RequirementsMinimum System Requirements for RPS and SQL Express on a Bit 2 GB PC with WindowsBit 1 GB 1Overview Install RPSInstall RPS with a Local SQL Database Install RPS en Use an Existing SQL Instance, Create a New SQL Instance, Prepare the Installation of the SQL Database and RPSRPS Install the SQL Database Install the SQL Database and RPSRPS En Install RPS RPS Install RPS with a Network SQL Database Then click Next En Install RPS Install the SQL Database and RPS En Install RPS RPS En Install RPS Use an Existing SQL Instance En Install RPS SQL Instance Name Boschsql User Name sa Password sql12345 RPS Database Name RpsdbCreate a New SQL Instance Overview Automatic Installation of RPSGenerate the RPSInstallation.ini File Customize the RPSInstallation.ini File Use the RPSInstallation.ini FileKnown Issues View the Installation Log FileBefore You Upgrade RPS Upgrade RPSUpgrade RPS with a SQL Database Select Start Run… Upgrade RPSUpgrade RPS en En Upgrade RPS RPS En Upgrade RPS RPS with a SQL Database, page 33 for upgrade instructions Upgrade RPS with a Microsoft Access DatabasePrepare the Upgrade for a Local SQL Database Prepare the Upgrade for a Network SQL Database En Upgrade RPS Upgrade RPS En Upgrade RPS RPS 3Share the SQL Database Automatic Integration Select ConfigSystemFile LocationsClick Upgrade Database Integrate the RPS Database Files into the SQL DatabaseConversion Log File 3Upgrade from RPS 5.11 or LowerCreate a New Database First Time Log-In Log into RPSChange the Password Set Security Levels by Panel Type for Networked Users MaintenanceModify RPS Modify, Repair, or Remove RPS2Repair RPS 3Known Issues4Remove RPS Revert to a Previous SQL Database Revert to Previous RPS Installation After SQL UpgradeEn Maintenance RPS En Maintenance RPS Revert to a Microsoft Access Database Select Config System File Locations Recover Old Database FilesSelect Config System Switch from a Client to a Network InstallationRPS Back Up the SQL or SQL Express Database Right-clickSQL Server Browser and select Properties Install SQL Server Management Studio ExpressClick the Protocols for Sqlexpress node En Maintenance RPS En Maintenance RPS General Operation Installation and AdministrationRPS Operation and Control Panel Account Notes RPS NotesD6412/D4412 and DS7240/DS7220 Control Panel Account NotesSeries D9112B1, D7212B1 D7024 and DS9400D8112 6DS7400XiV4-EXP Numerics IndexRPS En Index Page Bosch Security Systems, Inc