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 Sign up to answer
Community showcase
Posted Tuesday in Statuspage

How do your teams prepare for really high (planned) traffic days like Cyber Monday?

Hi there! Shannon from Statuspage here.  👋  With Cyber Monday quickly approaching, we're looking to hear from Atlassian customers – specifically from teams who touch incident response li...

61 views 0 5
Join discussion

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