Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
11 replies
Subscribers
8 subscribers
Views
3394 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
We are copying production data down to a test environment. We want to change th
kerrys
over 10 years ago
We are copying production data down to a test environment. We want to change the email addresses and passwords so that for testing we do not confuse production customers. Where are user email addresses and user passwords stored, so that we can run a database update script to adjust those over to a testing value?...
OriginalPostID-111920
OriginalPostID-111920
Discussion posts and replies are publicly visible
Parents
0
Mike Cichy
Appian Employee
over 10 years ago
Few comments:
1. Use server/_scripts/stop-suite.sh instead of checkpoint + service stop. This ensures transaction completeness.
2. Make sure you backup and migrate all DB data sources
3. When stopping engines, just check for k processes running. If none are running, your app is shut down.
4. Are Appian configuration settings in test in line with PROD? I would REMOVE all the smtp host configuration so that the app does not send any emails after migration.
By migrating prod kdbs you are essentially creating a clone of production, including all users and their profiles. Anything on test will be overwritten. Any testing that is being performed is going to have to be stopped. That is also one of the reasons why I think moving prod data to a different environment is a better idea.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Cichy
Appian Employee
over 10 years ago
Few comments:
1. Use server/_scripts/stop-suite.sh instead of checkpoint + service stop. This ensures transaction completeness.
2. Make sure you backup and migrate all DB data sources
3. When stopping engines, just check for k processes running. If none are running, your app is shut down.
4. Are Appian configuration settings in test in line with PROD? I would REMOVE all the smtp host configuration so that the app does not send any emails after migration.
By migrating prod kdbs you are essentially creating a clone of production, including all users and their profiles. Anything on test will be overwritten. Any testing that is being performed is going to have to be stopped. That is also one of the reasons why I think moving prod data to a different environment is a better idea.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data