Setting up Multiple Databases for your Blackbaud CRM™ SDK Development


It's Tech Team Tuesday again and time for another tip.

As a Blackbaud CRM™ SDK Developer sometimes you need to work on a local environment, but also test your code against a robust set of data. If you want to be able to select multiple databases from the Blackbaud CRM™ Login screen, here's a tip: in your web.config file configure the following:

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.

(image: screen capture from Blackbaud CRM™)

Tip: Remember that your databases and CRM instances need to be on the same versions and service pack. And, don't forget to bind a LoadSpec shortcut key for your new environment.

For more tips and tricks, subscribe to our blog!

© 2017 BrightVine Solutions | All Rights Reserved

Offices:

Boston*

Charleston*

Charlotte

Nashville

Tallahassee 

Jacksonville/ Savannah

Atlanta 

843-900-4287

  • BrightVine on LinkedIn
  • BrightVine on Facebook
  • Twitter
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