How to migrate Bold BI instance from one machine to another
Follow the step-by-step process below to migrate the Bold BI instance of Embedded Analytics Server from one machine to another, using the existing database connection.
Steps to back up the Bold BI Database
Follow the instructions below to backup and restore the databases of the UMS and BI tenants.
Steps to migrate the resource folder
Install the Bold BI application on the new machine, which is the new instance to where you want to migrate.
Stop the Bold BI application of the new machine by following the below KB article.
How to Stop and Start the Bold BI Application on Different EnvironmentNow, take a backup of the app_data folder of the new machine, which is available in the below location.
Once the backup is taken, delete the app_data folder on the new machine, then copy and paste the app_data folder from the old machine to the new machine location in where the resources files present.
Note that we need to replace the entire app_data location because some encrypted contents will be only decrypted with the key present in the app_data location. If the key mismatches, then we can't decrypt the existing information.
Once the backup is taken, make sure to stop the old instance of Bold BI application because if any changes made in the site won't be available in the new instance.
Environment | app_Data Location | |
Linux | /var/www/bold-services/application/ Default deployment location: /var/www/bold-services/application | |
Windows | {Deployed Location}/app_data/ Default deployment location: C:\BoldServices | |
Docker | Need to backup the persistent volume used for app_data | |
Kubernetes | For Kubernetes need to backup the Fileshare for different cloud providers. | |
EKS File storage | https://docs.aws.amazon.com/efs/latest/ug/awsbackup.html | |
AKS File storage | https://learn.microsoft.com/en-us/azure/backup/backup-afs | |
GKE File storage | https://cloud.google.com/filestore/docs/backups |
Steps to modify the URL in UMS
Follow the below guidance document to reset the database connection of the UMS in the new instance.
Reset Application Database – Admin Utility | Bold BIIf you are using IP, you can ignore this step and proceed directly to step 3.
a. If you are using the same custom domain, make sure CNAME record for your domain is mapped with the new IP address in the DNS provider.b. Alternatively, if you are using a different custom domain, create a CNAME record for your domain with the new IP address in your DNS provider, and then use that domain in Bold BI.
Refer to the KB article below to update your domain or IP in the new instance and skip Site URL configuration in Bold BI application and How to change individual tenant site URL sections of that article and continue further steps below.
The UMS service is ready with the restored database. Now, we need to update the UMS URL with the DNS or IP of the new instance in the application. We can update the UMS URL either through the UI or using admin utility. Refer to the sections below for instructions on how to update it.
Steps to modify the UMS database connection and URL
Update UMS URL using UI
Now start the Bold BI application of new instance by following the below article.
How to Stop and Start the Bold BI Application on Different EnvironmentGo to {new_instance_domain}/ums/administration page and login into the application.
Note: We need to access the UMS site directly without accessing the tenant site with the new machine domain or IP.
Example: {your_domain}/ums/administrationNow update the UMS URL with the new machine DNS or IP in the site URL, and also ensure the checkbox shown below is not checked because enabling this checkbox will update all the tenant site URLs also.
Then, click the Save button to save the changes.
Update UMS URL using Admin Utility
Like the UMS database connection reset using the admin utility, which is specified in the link, we can update the UMS URL.
- Open the utility location based on the Bold BI hosted environment as specified in the above link.
- Run the following command to update the UMS URL as shown below:
Syncfusion.Server.Commands.Utility.exe updatedomain -dns "<new_domain>” The UMS service is ready with an updated URL. To change the tenant site URL, you can refer to the section below. So start the new instance site by following the below article.
How to Stop and Start the Bold BI Application on Different Environment
Steps to modify the tenant sites database connection and URL
Update using UI
Go to UMS site listing page by clicking Sites option in the left panel.
{new_instance_domain}/ums/sites
Now, select Edit option from a specific site under context menu option,
- Provide the new URL here and click Next.
- Enter the tenant site's database information of the restored database and click Update.
- Repeat the above steps for all the tenant sites one by one.
- Now all the tenant sites on the new instance machine are pointed to the latest domain or IP with the restored database. So, restart the Bold BI application by referring to the below link and access the tenant sites.How to Restart Bold BI application
Update using Admin Utility
- Refer to the article below for instructions on how to update the database connections of bulk tenant sites using the admin utility.
- Now all the tenant sites in the destination instance are pointed to the restored DB and start or restart the Bold BI application by referring to the below link and access the tenant sites.
How to Restart Bold BI application - To update the tenant site URL for individual sites in the UI by referring to the above section Update using UI.
- Now stop and start the Bold BI to reinitialize the modified URL application settings.
Steps to modify the data store connection of Tenant Sites
Steps to modify the data source connection
- If you are migrating the data source's SQL database servers along with the Bold BI application, please create a support ticket using this link in order to get guidance on updating the connection string of the bulk data sources.
Note
- It is recommended to migrate the Bold BI database to the same or a higher version of the Bold BI instance in the new location. However, it is not recommended to use lower version of Bold BI in the new instance because during upgrade process we may altered the database tables or columns.
Related Links