Nonprofit News from Soft Trac

Why Sage MIP Fund Accounting Users Should Upgrade their MSDE to SQL Server 2005 Express

October 2nd, 2008 by Darla Hamlin

If you have been running your Sage MIP software with the MSDE version of SQL server, Soft Trac recommends that you upgrade to SQL Server 2005 Express Edition that is provided on your MIP Version 10 CD. Whether you have already upgraded your Sage MIP Fund Accounting software to Version 10 or are making plans to do so, following are some compelling reasons to also upgrade your MSDE SQL:

  • The SQL Server 2005 Express Edition has a 4 GB database limit. MSDE has a 2 GB
    database limit.
  • SQL Server 2005 Express Edition comes with a graphical interface allowing users to
    perform some basic admin tasks. MSDE does not come with a graphical interface.
  • Once a Sage MIP Fund Accounting database has been opened with SQL Server 2005, it can no longer be opened with SQL Server 2000. This is not an issue unless you need for Soft Trac to repair your database or other task offsite. Since all of our production machines have been upgraded, special provisions would need to be taken to perform the work. This would add unnecessary cost to the project.
  • Mainstream support for MSDE ends two years after the release of SQL Server 2005, in
    accordance with standard Microsoft lifecycle policies.

For more information about upgrading your Sage MIP Fund Accounting software and SQL Server 2005 Express, visit Sage tech support online at http://www.sagesoftwareonline.com. Don’t have a login and password, contact Soft Trac to find out how to one can be obtained.

If your organization is running the Full version of SQL, Microsoft has released a white paper
outlining reasons for upgrading to SQL Server 2005. You can download the paper at
www.microsoft.com/sql/techinfo/whitepapers/why-upgrade.mspx

Leave a Reply