After the acquisition of Great Plains in the early part of this decade, Microsoft made the move to replace Pervasive SQL, the existing database for Great Plains, with the MSDE platform. MSDE made sense at the time and allowed Microsoft to phase out the Pervasive SQL platform in a quick and easy fashion. For users still on the MSDE platform, what was once free and easy has become a ticking time bomb that needs to be defused.
The MSDE or Microsoft SQL Desktop Engine Platform has restrictions on it that will cause issues for any company that has grown since it first installed the Great Plains/MSDE solution. These limitations include:
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 English Query
No SQL books online
Additionally, the current MSDE version has been discontinued and will soon be no longer supported. As SQL is a back-end server, customers who have purchased this licensing probably are not aware of the serious issues that could affect their ERP application. The bottom line is that if your existing Dynamics GP solution is utilizing this database you should make all necessary arrangements to upgrade and move off of this platform ASAP.
Since 1985, Micro Force has been serving the New York Metro region as the Largest and Most Experienced GP-Only Gold Certified Partner.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.