top of page

Tech Team Tuesday: Setting up Multiple Databases for your Blackbaud CRM SDK™ Development

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

<connectionStrings>

<add name="LocalDB" connectionString="Server=DBSERVER;database=DB1;integrated security=sspi" />

<add name="SandBox" connectionString="Server=DBSERVER;database=DB2;integrated security=sspi" />

</connectionStrings>

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.

bottom of page