How to Synchronise Production Data to a Staging Environment
Keeping your staging environment up to date with production data is crucial for accurate testing and troubleshooting. Follow these steps to ensure a smooth synchronisation process while minimising data loss and inconsistencies.
1. Determine the Type of Backup Needed
Before syncing, decide whether you need a full or sanitised backup:
- Full Backup: Includes all production data, useful for internal testing and debugging.
- Sanitised Backup: Anonymises or removes sensitive user data, ensuring compliance with security and privacy regulations (e.g. GDPR).
2. Verify Instance Configuration
Before initiating the sync, check the production environment is using the correct option for development backup:
- Ensure Development Backup matches the latest backup type
3. Initiate the Synchronisation Process
Once the instance is ready:
- Start the sync process by clicking the Sync button in the MDOQ interface
- Select Synchronise all
4. Understanding the Risks
Syncing will overwrite existing staging data. Be aware of potential data loss:
- Code Changes: Any uncommitted changes in staging (not in source control) will be lost.
- Database Changes: Any data not included in the backup or specific staging-only configurations may be wiped.
- File System Changes: If syncing includes media or other files, ensure any necessary staging-specific assets are backed up.
By following these steps, you can ensure a smooth and reliable synchronisation between production and staging without unintended data loss.