Database refresh
A database refresh will allow you to overwrite an existing database with a copy from another environment. Most commonly, a refresh is needed to copy or sync the latest production database to a non-production environment. It may also be needed when you need a brand new database from a staging server copied to a non-production or production environment while onboarding. A refresh is beneficial when testing new functionality and you need a current copy of the data. To request this service, you must provide the required information detailed below, and submit a case through Support Central.
Required information
SaaS Operations will fulfill your request for a database refresh once we have the following information. You must include this information in your request.
- The source and destination locations – specify where the data is copied from, and where it's being copied to. For example, state that you need a database refresh from the production environment to the development environment.
Which components you need copied – some services have multiple databases. Be specific on which ones you actually need refreshed. For example, for Helix ITSM customers, we need to know which of these components need to be copied:
- For customers on 21.3.X version and above, the component AR includes BMC Helix ITSM, SmartIT Digital Workplace, Digital Workplace Catalog, Innovation Studio, Business Workflows and Virtual Agent)
- For customers on 21.3.X version and above, the component Smart Reporting (if available)
- For customers on 20.08 version and below, the separate components are AR/ITSM, SmartIT, Smart Reporting, Digital Workplace and Digital Workplace Catalog
Important
Select customers approved by BMC will keep the BMC Helix Innovation Studio - Reporting User or Smart Reporting service up to April 2024.
3. Web Services – specify whether or not you need these restored after the refresh (if applicable).
4. Custom integrations – if there are any details related to custom integrations that need to be restored from the destination environment after a refresh, you must specify what that is (if applicable).
Database refresh process
The following steps outline the high level database refresh process:
- The BMC SaaS Operations team takes the database backups and application backup which includes configuration forms data
- The BMC SaaS Operations team stops your applications (i.e. AR System, Smart IT, BMC Helix Digital Workplace, BMC Helix Digital Workplace Catalog, etc.)
- The BMC SaaS Operations team restores your database backups from the source database to the destination database specified.
- The destination database is overwritten by the database backups from the source; and the source and destination databases will be aligned moving forward.
The BMC SaaS Operations team restores the application backup and run a few database scripts to update the source references such as URL, hostname, and port on out-of-the-box forms.
Not included in database refresh
CCS configurations, email configurations, licensing, operation ranking, and UDM configurations will be retained per the original settings of your environment and will not be refreshed. Applications under BMC Helix IT Operations Management, including BMC Helix Operations Management, BMC Helix Continuous Optimization, BMC Helix Discovery, and common services like BMC Helix Dashboards, cannot undergo a database refresh.
- The BMC SaaS Operations team restarts your applications.
- Finally, The BMC SaaS Operations team performs sanity testing.
Helix ITSM configurations
Specific to Helix ITSM and Digital Workplace customers, there are several configurations that are set by default when a database refresh request is fulfilled. Although BMC recommends the default state, you must specify in your change request if the default configuration is not sufficient for your business requirements. For example, the email service is disabled after a refresh. If you need it enabled, you must state this in your refresh request.
Task | Default state after a refresh (destination environment) |
---|---|
Email service | Disabled |
Email configurations | Disabled |
Email messages | None are synced with the new environment |
Broadcast service (enabling or disabling of broadcast service for Smart Reporting) | Disabled |
Broadcast reports (retrieving Smart Reporting schedules from the source) | All are deleted |
Escalations | Disabled |
Custom filters | Re-applied if requested |
ITSM transactional data | Remains as is |
Digital Workplace Catalog transactional data | Remains as is |
Important:
The source environment will remain as is.
A database refresh will require downtime on your destination environment for the duration of the change.
Environment refreshes can be performed only where the two environments are on the same version (application and database).
For Helix Digital Workplace customers:
- if you purchased the Advanced service, a refresh will include both the Digital Workplace database and the Catalog database.
- if you elect to not have transactional data refreshed, the next request ID will be set to 1.
For Helix ITSM customers, if you elect to not have transactional data refreshed, the next fulfillment record ID will be set to 1.
Your refresh is complete once you validate the solution on the destination environment.
Comments
Please add more details about the whole refresh process.
It is important to understand exactly what is happening.
Thank you for your feedback, Andreas. I will check with the SMEs and add more information about the refresh process.
Regards,
Dhanya
Hello Andreas,
The process is we back up the environment that you've requested to copy over and restore that backup onto the target environment. For example, a Production to Dev database refresh will copy over the production data and overwrite the existing Dev database such that the Dev environment is an exact replica of Production for your development and testing needs.
It will depend on the type of database request you have submitted through the case based on the four requirements under the "Required information" section. Was there anything specific you were hoping to understand? If so, would you be able to provide an example?
Thanks,
Dhanya
Thanks Dhanya
We now know everything we wanted to know cause we asked the right person from BMC. Both of these things are not documented here.
1. High level steps for DB Refresh:
2. Do you import data from the prior state of the target env back into the target env after importing the source env data?
Answer: We restore configuration related forms back to target which was taken as backup before restore. (E.g. CCS configuration data, WS filters, Email Configurations)
Thank you for this information, Andreas. I have added the high-level process on this page.
Regards,
Dhanya
What exactly is meant by "Broadcast service" and "Broadcast reports"?
Broadcast service = disabling/enabling of broadcast service for Smart Reporting
Broadcast reports = whether to bring Smart Reporting schedules from the source
Restore Web Service Filters Backup (missing from the table on this page for some reason) = change team takes a backup of the filters having webservice references from the target system and then imports them back once the DB refresh is finished
Thank you for your suggestion, Andreas. I have updated this page accordingly.
Regards,
Dhanya
Log in or register to comment.