Is Microsoft SQL Server 2008 Express right for your database needs?

Posted by Lee Collyer on Mon, Aug 15, 2011

It could be.   Here are the basics…..

SQL Server Express is a free edition of SQL Server that is great for developing and powering desktop, web and small server applications.   If you are using Accpac ERP, are interested in upgrading from Pervasive.SQL to Microsoft SQL, and you require 1GB of memory addressing with a max database size of 10GB then this free version of SQL might just be the ticket. SageCRM only runs on a Microsoft SQL database version 2005 or 2008. Therefore the Microsoft SQL Server Express edition could be a good choice to begin with.

Microsoft SQL Server 2008 R2 Express

Top Features for Microsoft SQL Server 2008 R2 Express

  • Same database engine as other versions of SQL Server.
  • Easy Backup and restore.
  • Available with a graphical management tool.
  • Offers reporting capabilities, full-text search, and spatial support.
  • No User limitations

Some restrictions to be aware of

  • Supports 10 GB of storage per database.
  • 1 GB of memory
  • 1 processor
  • SQL Reporting tools are limited*
  • Management Tools are limited*

 *These limitations are not required to run the ERP application. Click here to view the complete list of the Standard vs. Express comparisons

Equation has successfully installed Sage Accpac with Microsoft SQL Server 2008 Express, working with clients that fit the aforementioned criteria, but it is always advisable to have a discussion with your project team regarding the SQL Express option to see if it is the right solution for your specific needs.

Learn more about Microsoft SQL Server Express Edition.

Click me

Topics: Sage 300 (ACCPAC)

Submit a Comment

Need Help Now?

Request a Call