Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Product Forums » The Raiser's Edge » Implementation/Conversion » SQL 2005 or SQL Express

SQL 2005 or SQL Express

Last post 05-04-2009 4:46 PM by Ken Kogler. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-04-2009 4:03 PM

    • Chris Parrish
    • Top 500 Contributor
    • User Since: 2004
    • Posts 22
    • Organization: Colorado AIDS Project
    • Products:  The Raiser's Edge

    SQL 2005 or SQL Express

    Reply Contact

    Did I read somewhere that there is a limited number of records that can be housed on SQL Express as opposed to SQL 5000?

    Chris Parrish
    Development Officer - Database
    Colorado AIDS Project
    chrisp@coloradoaidsproject.org

  • 05-04-2009 4:46 PM In reply to

    • Ken Kogler
    • Top 500 Contributor
    • Posts 21
    • Organization: Concordia Seminary
    • Products:  Blackbaud NetCommunity, The Financial Edge, The Raiser's Edge

    Re: SQL 2005 or SQL Express

    Reply Contact

    Hi Chris,

    SQL 2005 Express Edition is limited to a database size of 4Gb. I don't believe there's any limit to the number of records -- in the sense that you're limited to a certain number of rows in a table -- but the more information you have on a constituent, the larger their records will be, and that'll get you closer and closer to the 4Gb cutoff. If you're embedding documents on action records, your database size will also grow MUCH faster.

    Constituents add up fast. I've got about 250,000 people and 950,000 gifts, and my database is around 8Gb, and that's without embedding documents.

    You can get all kinds of other details about the difference between Express/Standard/Enterprise at this link:
    http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Page 1 of 1 (2 items)