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 votes

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 Join to answer
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,069 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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot