changing SQLnode from existing to another machine without re-installation

currently i am using my localhost sql. now what i am thinking is keeping bamboo on same machine but I need to point out sql data to another machine. Is there any option to achive this without re-installation.

1 answer

0 vote

Hi Simhadri,

The process in Moving your Bamboo data to a different database may be of use:

Alternative DB migration

If the database systems are:

  • the same (for example, you are moving from PostgreSQL to another PostgreSQL) OR
  • compatible (for example, you are moving from SQL Server 2005 to SQL Server 2008),

you can move the data manually. To migrate the data:

  1. Stop the Bamboo instance that is using the source database.
  2. Manually transfer the data.
  3. Go to <bamboo-home> and open the bamboo.cfg.xml file.
  4. Provide the properties of the new database.
  5. Start the Bamboo instance.

Once you move the database data and modify the bamboo.cfg.xml you should be set once you restart Bamboo.

Cheers,

Branden

sothat after approaching the above procedure shall I replace this hibernate.connection.url property value eith my desired server node.

is it enough (or) still I need any changes.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Renan Battaglin
Published May 18, 2017 in Bamboo

FAQ: How to Upgrade Bamboo Server

Bamboo 5.9 will no longer be supported after June 12, 2017. What does this mean? As part of our End of Life policy, Atlassian supports major versions for two years after the first major iteratio...

1,319 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you