How to Refresh On-Prem New Production Enterprise ERP Environment from Current Production During Parallel Testing of New System
Description of Issue
- We have built a new set of on-prem servers for Enterprise ERP during our Server Migration appointment and we need more current Munis data in the new system for testing.
- OnPrem How to Refresh a Non-Live Production Environment
- How to refresh a non-live production environment from a current production environment when the current production is on a lower major version of Munis then the non-live production environment
- Moving current production data into a non-live production environment for testing purposes
Context
- EERP (formerly Munis)
- On-Prem Specific
- Data Refresh
- Server Migration
- Copy EERP Prod DB to New Host
Cause
Instructional
Resolution
Access required for performing the tasks outlined below:Â
- Access to the database servers
- Access to Tyler Deploy
- Access to an account with system administration rights within Tyler Hub and Enterprise ERP
Before Starting:
You may be eligible for a Data Refresh appointment with our Enterprise ERP deployment team:Â How to Schedule a EERP Data Refresh Appointment with Tyler
Preparation:
- Run the Upgrade Prep Utility's Data Integrity Assistant in the Source environment to ensure source Munis database data conditions are clear: Running the Upgrade Prep Utility
- Back up the Target Enterprise ERP Database in case you need to revert back to it: Backup a SQL Database
Important: User account roles, Printer Definitions, and ReadyForms Delivery Definitions are stored in the Munis database and overwrite the target environment when refreshed. To preserve these configurations from the target environment, perform the following:Â
- If you are planning to upgrade or update Enterprise ERP in the target environment as part of this refresh, and you would like to preserve the items below, it's recommended to update the target environment first before performing the following preservation tasks, to minimize chances of export incompatibility.Â
- Preserve User Accounts and Roles in the target environment before starting the refresh: How to Preserve User Accounts and Roles when Refreshing a Munis Environment
- Preserve Forms Printer Definitions in the target environment before starting the refresh: Export and Import Printer Definitions and create a backup
- Preserve ReadyForms Delivery Definitions in the target environment before starting the refresh:Â How to Export and Import ReadyForms Delivery Definitions
Perform the Refresh:
- Backup the source Munis database: Backup a SQL Database
- Copy the backup file to the new database server and restore the backup to the target Munis database: How to Restore a SQL Database From Backup
- Force-Redeploy the existing version of Enterprise ERP in the target system. Make sure the keyword "transfer" is present in the tenant name:Â How to Run or Schedule an Update in Tyler Deploy for a Product
- If Server Prerequisites are indicated, Install Server Prerequisites in Tyler Deploy
Post-Refresh Tasks:
- If desired, re-import the preserved account roles, printer definitions, and delivery definitions. Follow: How to Preserve User Accounts and Roles when Refreshing a Munis Environment
- If DocOrigin is owned for forms printing, verify and update the IP address of the Forms server: How to Update the DocOrigin Server IP or Server Name in EEERP Menu
- If IVR or ExecuTime is owned, update those webservice user passwords: How to reset EXECUTIME password in Munis. The same process referenced in this article is applicable for the IVR user, re-test these integrations when complete.
- Optional: Refresh the non-production environments in the new system. How to Refresh a Non Production Munis DatabaseÂ
Additional Information