All,
Back at G-Log, we often had to take production databases from our customers and bring them into QA for performance testing - or to duplicate client issues. When doing so, it was critical that we didn't notify the customer's customers, nor their carriers when processing transactions into the system. These same steps can help you move data from your PROD environment, back to a PREPROD, PERF, TEST or DEV environment with the same protection.
Below are my recommendations, to ensure that external parties and systems aren't notified.
After moving your data (either via import/export or DB clone) to the TEST environment, complete the following:
Hope this helps!
--Chris
Back at G-Log, we often had to take production databases from our customers and bring them into QA for performance testing - or to duplicate client issues. When doing so, it was critical that we didn't notify the customer's customers, nor their carriers when processing transactions into the system. These same steps can help you move data from your PROD environment, back to a PREPROD, PERF, TEST or DEV environment with the same protection.
Below are my recommendations, to ensure that external parties and systems aren't notified.
After moving your data (either via import/export or DB clone) to the TEST environment, complete the following:
- Ensure your TEST system utilizes an SMTP server which doesn't relay to outside domains.
- Ensure your TEST system is located within a segregated network, which doesn't allow it to connect to production integration systems.
- Ensure the following property exists within your TEST glog.properties file, under the Custom Properties section:
- [email protected]
- Run the following SQL command against your TEST database (just to be sure!):
- UPDATE CONTACT SET EMAIL_ADDRESS='[email protected]';
- Startup your TEST instance and login as DBA.ADMIN, then modify all of your External Systems, and ensure that no production integration systems are referenced.
- This includes digging down into each WebService and ensuring the associated WSDL files don't specify a production endpoint
Hope this helps!
--Chris
Comment