Summary
This article describes the options available for managing the InfoBurst database repository and repository management best practices.
See Repository Management (Build 240) for repository management details for Build 240.
Backups
SQLite Repository Users
If the repository type is SQLite and a virtual server backup is not possible, then schedule a backup of the SQLite repository.
Repository Management
See Repositories for details on the following actions:
- Create a new repository
- Connect to an existing repository
- Switch to an existing repository
Copying and Restoring a Repository
Use the following process to copy and restore a repository from one InfoBurst environment to another. The most common use of this process is the copying of the production repository for use in an InfoBurst test environment. The testing process can vary based on how InfoBurst is utilized and testing requirements. InfoSol offers services to help plan and guide testing. Please contact InfoSol for details.
Recommendations
- The steps described below are generic and can vary based on environment and need. We recommend consulting InfoSol to develop a plan specific to your requirements.
- Disable Schedule and Event Processing and Simulate Deliveries (see below) to prevent delivery of duplicate content from the target environment. These settings can be reverted once steps are taken to disable duplicate schedules and reconfigure or disable duplicate deliveries.
- Obtain a license for the target server and store in the application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Ensure server dependencies match the source server (see Move an Application Server > Recommendations)
Repository Copy & Restoration
Source Server (Server #1)
- Stop the InfoBurst service
- Make a backup copy of the InfoBurst database repository
- Restore the repository copy for use by Server #2
- Start the InfoBurst service
Target Server (Server #2)
| Restore the Repository Copy |
|
| Reset Schedules | Jobs may not start correctly if the repository copy was made when jobs were running in the source environment. Run IBResetSchedule to remove orphaned jobs.
|
| Update ServerName and UIURL |
|
| Disable Schedule/Event Processing & SimulateAllDeliveries | Disabling Schedule/Event Processing and SimulateAllDeliveries are optional and can be used when you do not want schedules to run or content to be delivered.
|
Update Server License |
|
| SSL | If the source server had SSL enabled, then the repository copy will contain that server's SSL certificate information. The SSL certificate information must be updated. Follow the instructions in the Change SSL section of the following article: https://help.infosol.com/en/support/solutions/articles/19000019266-ssl |
| XDC Users | Re-run XDCs on Server #2 to rebuild caches and update external dashboard/application references to new server if applicable |
Moving a Repository
- Stop the InfoBurst service
- Move the database repository
- Open a command prompt (Run as administrator)
- Change directory to the application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Enter SwitchRepo
- Enter 2 (Connect to another repository)
- Enter number corresponding to your database type
- DB User: Enter database username
- Leave username and password blank to use Windows Authentication to SQL Server. The Windows account assigned to run the InfoBurst service will be used.
- DB Password: Enter database password
- Database Server: Enter Database Connection String
- Catalog: Enter database name (SQL Server only)
- Enter YES to switch repository
- Restart the InfoBurst service
Change Password for Existing Repository
Use the SwitchRepo utility to change the password for the current repository connection
- Stop the InfoBurst service
- Open a command prompt (Run as administrator)
- Change directory to the application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Enter SwitchRepo -pwd
- Enter new password
- Start the InfoBurst service