Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software ? the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence ? via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. So ? Great Plains was running on MS SQL Server, Ctree (Faircom ? if you remember 1995-96 Macintosh era), Pervasive SQL (Btrieve). Microsoft obviously had no plan to keep this multiplatform capability and Great Plains was optimized to MS SQL Server and with the introduction of MSDE ? the need to keep entry level Dynamics on Ctree/Btrieve disappeared.

Microsoft Great Plains Business Solutions, later renamed to Microsoft Business Solutions was sending multiple signals to Dynamics customers to migrate to SQL Server, later on to upgrade to Great Plains Standard on MSDE. Recently it promoted all the clients who own Great Plains on Ctree/Pervasive ? so now they technically own so called Great Plains Standard. All they need to do is pay for Migration (around k$3 + consulting fee to whoever your MBS VAR is).

Unfortunately MBS did several rough turns in the process of this migration from ctree/Pervasive to SQL/MSDE.

Until early 2004 you could see support expiration date for Great Plains 7.5 on Ctree/Pervasive was July, 31, 2005. In about April, 2004 ? Microsoft roughly changed it to December 31, 2004. This actually exposed all the clients with regulation-related modules (such as US Payroll ? where you rather do not risk with printing W2s without support) to serious problems

Clients who migrated to Great Plains standard are now in the feeling that they paid for something that is free now. See above ? all the low price GP clientele now technically owns GP Standard

Ctree/Pervasive clients with high volume of employees count in GP Payroll/HR now have to cut it to 500 employees due to the cap for GP Standard. You can imagine frustration, especially due to the fact that a lot of mid-size and big companies were running very cheap Dynamics on Ctree for just Payroll/W2 filing. This was a very nice alternative to products like Abra HR ? not any more.

What to do. Well, if you plan to stay with GP ? the only alternative is to migrate to MSDE. Contact your MBS VAR (or call us directly: 1-866-528-0577). You will be given Migration Tool quote ? then install MSDE and Great Plains with exactly the same accounts structure that you have on Pervasive/Ctree. Tune Migration Tool, select all the tables in all the modules, click the button and wait a few hour ? and you are in the SQL World!

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Illinois, California, Texas, Florida, New York, Georgia, Colorado, Minnesota, Washington and having locations in multiple states and internationally www.albaspectrum.com, he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

akarasev@albaspectrum.com

---

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Change Your Word Docs in Record Time!

Anyone who has ever used Microsoft Word knows that it... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

Call Alert Notifications - Free Answering Machine Software for PCs

If you're online using a dialup Internet connection, you'll probably... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

The Top 5 Wrong Reasons For Not Hiring Testers

Considering whether or not your software company should hire a... Read More

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More