CAUTION: Making a change to any file (including the web.config file) inside or under the ..\bbappfx\vroot folder will cause the IIS worker process to recycle. This will halt all running business processes which may cause further data-related issues. This adjustment is best done when you know there are no activations, queues, or ETL refresh processes or other business processes running. To see if it’s a good time to add/edit files, check for running business processes:
Admin > Business Processes > Process type - blank, Status - Running, and click Apply.
1) Attach a backup of the original database or already have the secondary database attached
2) Create a copy of the web.config found in the ..\bbappfx\vroot\ folder and then edit the original in notepad or similar editor:
Look in the top 50 lines of the file for the main appSettings section and the add key “DBList”:
<add key=”DBList” value=?? />
(The “??” will read what you normally see in the dropdown for BBDM when logging in and is a semi-colon separated list)
<add key=”LiveDB;TrainingDB” />
For each DBList item seen in the <appSettings> section, we need a connection for it here. You should already have one connection for the existing database and if the secondary database is on the same SQL instance you can copy/paste this line and adjust it to read the new database.
<add name=”LiveDB” connectionString=”Server=[SQLSERVERINSTANCE];database=[DATABASENAME];integrated security=sspi” />
<add name=”TrainingDB” connectionString=”Server=[SQLSERVERINSTANCE];database=[DATABASENAME];integrated security=sspi” />
NOTE: For best performance, use a secondary SQL server for this secondary database or consider creating a complete test environment.