Updating the Test Environment by copying the Prod DB and the DATA directory....will it really work?

[bauerprocessconsulting]

I have been assigned a task to update the Test Enviromnent by copying the Prod database from Prod to Test.

I have

- copied the prod data directory to the test environment, and

- copied the prod DB to the test environment (access rights configured, etc...)

I am - to say the least - cautious / reluctant to actually start the services - afraid that i will mess up production somehow, even though i have kept the configuration/installation files from the original Test environment (the test environment pre-copying of DB/data directory)

Will this work?

[Alexis Robert · Accepted solution]

Hi, 

this setup should work fine, you just need to make sure that:

• your test instance does point to the test DB in your dbconfig.xml file in JIRA_HOME
• your JIRA_HOME is actually properly set up
• you have the test url set as the base url on your test instance, otherwise all your links will point to the prod instance

Let me know if it works, 

--Alexis

[Andy Heinzer]

Yes it will upgrade when you start Jira.   And I agree with Alexis' comment above.  The only thing I would add, if you're production is still up and running when you do this, it would be advisable to go into your test server's startup options and disable the mail.   These are the flags:

-Datlassian.mail.senddisabled 
-Datlassian.mail.fetchdisabled 
-Datlassian.mail.popdisabled

That are found in either the setenv file or in the windows service settings depending on your environment.   You do not want your test instance to also connect to the same mailboxes at the same time production does.  Having two such Jira installations connecting to the same mailboxes is know to cause problems.

[bauerprocessconsulting]

Thanks for help - worked like a charm

[bauerprocessconsulting]

Thanks for your answers Guys - it worked, no problems.