restore stash to other environment (Integration plattform)

Martin__SCM_Support

Hi

We are creating our stash integration platform, for testing changes before we implement them on production.

We would like to restore most of the data from production to this system and a hand full of repository, most, because we do not want to restore i.e. directory settings or application links.

So we made a Database backup and are trying to restore some single tables, but because of a missing DB schema we do not really know which table we need.

Actually we restore the following tables:

project.sql
sta_normal_project.sql
repository.sql
sta_activity.sql
sta_repo_activity.sql
sta_pr_activity.sql
sta_pr_comment_activity.sql
sta_pr_diff_comment_anchor.sql
sta_pr_merge_activity.sql
sta_project_permission.sql
sta_pr_participant.sql
sta_pr_rescope_activity.sql
sta_pr_rescope_commit.sql
sta_pr_rescope_request.sql
sta_task
sta_comment
AO_BD73C3_PROJECT_AUDIT.sql
AO_BD73C3_REPOSITORY_AUDIT.sql

Most works fine, but we have some trouble with the pull request view.

How do other handle this?

 

Thanks

Martin

ThiagoBomfim

Hi Martin,

We recommend you do that by backing up Stash on the production server and then restoring it on to the Integration server using the backup client. Have a look at the docs below. This methodology is detailed and should work:

• Backing up Stash using the client
• Restoring Stash to use a newly created DB

This will though restore your production directory settings or application links – which you can remove once it is up and running.

I hope it helps.

Best,
Thiago