Changing databases' names/ Two Fortresses pointing to one DB

[fryhard]

Hey,

We would like to install two different instances for Fortress. One to manage our Live environment's content and the other to manage our Staging environment's content. These will run off two different servers, but we are thinking of using the same database sever. This obviously leaves us with the problem that the Staging and Live installs will need to point to different database on the same server.

I did some Googling to try and find a solution to this problem, but had no luck. Is there any way to run two instances of Fortress of the same database? Or would we need to use two separate database instances?

The problem is cause by Fortress always naming its databases sgdragnet, sgmaster and sgvault.

Thanks for the help!
Brendan

[Beth]

You would need two instances of SQL.

What is the difference between the code that will be live and the code that is staging? There might be a better way to deal with this.