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

---

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

Microsoft Business Solutions Great Plains is mid and even corporate... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

Microsoft Blues

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

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Microsoft Great Plains Partner Selection: Overview

Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More