Main image
14th January
2010
written by Ed N.

When Microsoft acquired Great Plains in the early part of this decade, they made the move to replace the commonly used database, Pervasive SQL, to the MSDE platform.  At the time, the MSDE database made sense and allowed Microsoft to easily phase out the Pervasive SQL platform.  Now, for users who are still on the MSDE platform, what was once free and easy is now a ticking time bomb that needs to be defused.

As a platform, the MSDE or Microsoft SQL Desktop Engine, had restrictions on it that will cause issues for any company that has grown since it first installed the Great Plains/MSDE solution.  These limitations are:

  • Support of up to 2GB of RAM
  • 2GB database size limit
  • 5 concurrent users or less
  • Support for up to 2 CPU on a Windows NT or Windows 2000 server
  • No publishing for transaction replication
  • No Database Server Failover Support
  • No full-text search
  • No GUI interface
  • No OLAP
  • No English Query
  • No SQL books online

Additionally, this version has been discontinued and will soon be no longer supported.  As SQL is a backend server, those customers that purchased this licensing probably do not realize the serious issues that could affect their ERP application.  The bottom line is that if your Dynamics GP solution is using this database you should make all necessary arrangements to upgrade and move off of this platform.

Whether you are a current customer of Micro Force or not, we are available to check your system to see if you are on the MSDE platform and if so we can migrate you to a more stable platform.

Share
Tags: , ,
Comments are closed.