What's the best practice to achieve database isolation for Bamboo branch build?

[Georges Auberger]

Automatic Bamboo feature branch builds are great. The problem is that now each branch will run its own integration build periodically.

What is the best practice to ensure that each branch build tests are isolated from each other when they execute against a common database?

[Quinton McCombs]

So far the only answer that I have found is to dedicate an agent to the bamboo project.  This causes all build within that project to single thread using one agent.  It is far from ideal but it does prevent concurrent build from hitting the same database.

[Shaunt Kojabashian]

I'd like to know this as well... The Git feature branch workflow looks awesome however I have no idea how to incorporate that with a database project and CI.