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

In The News:

pen paper and inkwell


cat break through


Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More

C++ Function Templates

C++ Function templates are those functions which can handle different... Read More

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

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

Microsoft C# vs. VB.Net

Hi, Guys,I believe a lot of programmers are trying to... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... 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

Making The Decision To Automate Your Software Testing

Not every software testing project can or should be automated.... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

Looking for an Alternative to Microsoft Office? You Should Be!

Now is the time to look at an alternative to... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

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

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Computer Based Language Development and Spell-checking

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

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

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

Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

This is a short article, written in question/answer/FAQ style to... Read More

ERP Implementation: Success Factors

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

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Twelve Things You Should Know to Save on Computer Software

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