Migrate Report Server database to a new server

Knowledgebase English KB
1

Klicke hier für den deutschen Artikel.

Task

To migrate the primary database of the Report Server to a new server, proceed as follows:

  • Create a backup of the database to be migrated.
  • Import to the new server.

Important: Please note that the database on the system to be imported must always be named combitReportServer. The standard system does not allow changing the database name.

Execution

  • Open the configuration file C:\Program Files\combit\combit Report Server\WebUI\privateSettings.config as an administrator in a text editor.
  • Set the value for the key IsDbReady to false (<setting key=“IsDbReady”>false</setting>) and save.
  • Restart IIS (e.g., enter iisreset via a command line with elevated rights and confirm).
  • The next time the Report Server is called up, the setup wizard appears, and the “new” database can be specified and saved. The database is not overwritten during this setup process. However, it is recommended to keep a backup copy of the database.

The new connection to the database server can be verified under Management > Advanced Settings.