Sync Confluence prod instance 6.6.6 to Dev Instance 6.6.6

[Roja Gurram]

Hi All,

How to sync/clone from Confluence Production Instance to Dev Instance? ( Both are same versions )

Could someone please let me know step by step which could be easy for me to do the same.

[Alexis Robert]

Hello, 

if your dev instance is already installed and configured, you only need to dump the production database and import it in your Dev database.

Let me know if this helps, 

--Alexis

[Roja Gurram]

Hi Alexis,

Yes, Dev instance  is an existing one.

you only need to dump the production database and import it in your Dev database. - Please tell me whcihone/how do i take this production DB backup and how do i import these DB dump into Dev instance ?

Please help me with steps.

[Alexis Robert]

Hi @Roja Gurram , 

this step is usually done by your database administrator or system administrator. I do not know what type of database you're using, so it depends.

[Roja Gurram]

Hi Alexis,

We are using Microsoft SQL Server.

Another question is : How to copy Whole Confluence Production into Dev instance pls?

Because i need to upgrade the Confluence version 6.6.6 to the 7.4 version before doing this i need to test this in Dev instance and version is same for both Instances.

[Alexis Robert]

Hi @Roja Gurram , 

I'm not familiar with SQL Server, as I said you will definitely need to check with your database administrator to copy the Confluence database.

For the upgrade, you can follow this procedure to upgrade to 7.4 : https://confluence.atlassian.com/doc/upgrading-confluence-4578.html

[Roja Gurram]

Hi Alexis_Robert,

DataBase is fine.

What would be the remaining things in Confluence except Database? How do we do that Eg: Home directory , Install directory....

[Alexis Robert]

Hi @Roja Gurram , 

you can copy both HOME and INSTALL directory to your dev instance. You will only need to edit your CONFLUENCE_HOME/confluence.cfg.xml file to remove the production database settings and put your dev database settings instead.

[Roja Gurram]

Hi Alexis_Robert,

Thanks for the update.

Apart from these is there anything still we need to make changes ?

I was taking backup of HOME directiory in Production but it was keep failing to copy.

Do you know why this is happening ?