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.

#Customization #SDK

© 2017 BrightVine Solutions | All Rights Reserved

  • BrightVine on LinkedIn
  • BrightVine on Facebook
  • Twitter

Contact BrightVine

Offices:

Boston*

Charleston*

Charlotte

Nashville

Tallahassee 

Jacksonville/ Savannah 

843-900-4287

Let's Connect

BrightVine Solutions, Inc. (BrightVine) is a member of the Blackbaud partner network. BLACKBAUD®, THE RAISER'S EDGE®, BLACKBAUDINTERNETSOLUTIONS®, BLACKBAUD CRM®, and RAISER'S EDGE® are registered trademarks of Blackbaud.  BRIGHTVINE, the BRIGHTVINE® LOGO, BRIGHTVINE DATALOADER® and DELIVERING EXCELLENCE FOR GOOD® are registered trademarks of BrightVine Solutions.

 

All other third-party trademarks mentioned on this website are the property of their respective owners.  Learn more about BrightVine on our blog