As a Blackbaud CRM SDK™ Developer sometimes you need to work local but also
test your code against a robust set of data. Setting up a second database should as easy as pie.
If you want to be able to select multiple databases from the Blackbaud CRM™ Login screen set up your web.config file in this way:
Under your appSettings in your Web.Conig file add this key
<add key="REDBList" value="LocalDB;SandBox" />
Under your connections string section add your database server links
<add name="LocalDB" connectionString="Server=DBSERVER;database=DB1;integrated security=sspi" />
<add name="SandBox" connectionString="Server=DBSERVER;database=DB2;integrated security=sspi" />
Once everything is setup you will get a Database selection link at your default page for CRM.
Tip: remember that your databases and CRM instances need to be on the same versions and service pack. Don’t forget to bind a LoadSpec shortcut key for your new environment.
BrightVine provides application management services for self-hosted Blackbaud CRM™ clients. We can assist with upgrades, patching, system performance, load balancer configuration, and more! Want to learn more? Email us today.