changing SQLnode from existing to another machine without re-installation

Question

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.

simhadri mallikarjun · Answer

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.

somethingblue · Answer

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:

* Stop the Bamboo instance that is using the source database.
* Manually transfer the data.
* Go to <bamboo-home> and open the bamboo.cfg.xml file.
* Provide the properties of the new database.
* 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