When you installed Bamboo, you would have connected Bamboo to an external database, or used the internal HSQL database that ships with Bamboo.
You may later wish to use a different database. For example, the embedded HSQL database is suitable for evaluation purposes only — you would typically move to an external database before deploying Bamboo in production.
To move your Bamboo data to a different database:
- Back up your Bamboo data as described in Exporting data for backup. Note the filename and path of the exported file for use in Step 8 below.
- Shut down your old instance of Bamboo.
- If your old instance of Bamboo was configured to start automatically (e.g. as a Windows service), disable it.
- Install a new instance of Bamboo as described in Installing and upgrading Bamboo. Specify a different Home Directory and Installation Directory from the directories used by your old instance of Bamboo. (If you use the same locations, your existing data will be deleted.) See Locating important directories and files.
- Launch your new instance of Bamboo. You will see the Setup Wizard.
- At Step 1 of the Setup Wizard, ensure that your new Configuration Directory, Build Data Directory and Build Working Directory are in different locations to your old instance of Bamboo. See Locating important directories and files.
- At Step 2 of the Setup Wizard, select your new database and follow the appropriate instructions for your chosen database:
- At Step 3 of the Setup Wizard, select Import existing data and specify the export file created in Step 1 above.
- Wait while Bamboo imports your data. (You will not need to complete any more steps of the Setup Wizard.)
- When the data import has finished, restart your new instance Bamboo.
- Re-index your Bamboo data as described in Optimising or re-indexing data.
- Verify that your build results and system settings look the same as before.
Alternative DB migration
If the DB system is the same (let's say, moving from one PostgreSQL server to another PostgreSQL), or a compatible one (for instance moving from SQL Server 2005 to SQL Server 2008), the DB migration can be done by the following steps:
- shut down Bamboo
- manually transfer the DB from SQLServer 2005 to SQL Server 2008 (or from one version of PostgreSQL to another compatible version – as long as the DB backup/restore works)
- change the DB credentials from the BambooHome/bamboo.cfg.xml file to point to the new location
- start Bamboo, and it should use the new DB.