Software Information

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


MORE RESOURCES:

Sony MEX-BT3700U first look (video)
CNET News, CA - 5 hours ago
... Car Tech booth at CES 2009 to install its MEX-BT3700U bluetooth-enabled CD receiver, which features hands-free calling and A2DP stereo audio streaming. ...


Sony expands XPLOD line of in-dash receivers
CNET News, CA - Jan 8, 2009
Three of Sony's new head units feature Bluetooth technology for simple hands-free phone calls and audio streaming (with a Bluetooth compatible phone). ...


Find Daily Online Shopping & Automobile Industry News - Reviews ...
Infibeam, India - 38 minutes ago
... audio and video playback, photo viewer, FM radio, voice recording, and Bluetooth capabilities such as phone pairing and stereo audio streaming. ...


Samsung's 2009 Plan: Green, LED TVs; 240-Hz Tech
PC Magazine - Jan 7, 2009
Both players connect to 802.11b/g/n wireless networks and incorporate Netflix video and Pandora audio streaming. These devices will upconvert standard DVDs ...


Sonos Cranks UP Internet Radio Offering
Smart House, Australia - 21 hours ago
By David Richards and TWICE | Friday | 09/01/2009 Consumers who buy the Sonos wireless audio systems listen to more music more often after their purchase ...


Junior Blues this weekend
The State Journal-Register, IL - 11 hours ago
There is no audio streaming or radio. FOR THE RECORD: The Blues (9-18-5) are in fourth place and Wichita Falls (13-12-4) is in third place in the South ...


2009 CES Wi-Fi Round-up Day One
Wi-Fi Planet, CT - 16 hours ago
"We're showing how direct Wi-Fi access can transform the audio streaming experience, but we also envision G2 Microsystems' technology simplifying other ...


Lady Buffs hit road for crossover games
Amarillo.com, TX - Jan 7, 2009
Radio/Internet: KGNC (710-AM), 6:30 pm; streamed live at www.gobuffsgo.com; audio streaming at www.kgncam.com. Did You Know? WT has won 17 straight games ...


CNET News

JVC adds seven new CD receivers to 2009 lineup
CNET News, CA - Jan 8, 2009
The KD-R900 also features hands-free phone calling and A2DP wireless audio streaming capability via an included USB Bluetooth adapter and high-quality ...


Synology® Announces Disk Station Manager 2.1 Beta
1888 Press Release (press release), TX - Jan 6, 2009
Audio streaming and auto-discovery feature that simplifies IP camera setup prove the Synology Surveillance Station 2 to be a great alternative to ...

Audio-Streaming - Google News

Generic Club Football UK E-shop  Top of Page home | site map  home Bookmark Us Now ctrl+d 1st 4 Games, shopping via this site cost no more than going direct and can often save you money with special offers. with questions or comments about this website, contact: Doug Carpenterposter shopping directory, shopping mall, poster online stores, directory, shopping mall directory, online shop, gifts, posters, art, prints, artist, order, malls, internet mall, shops 1st4games offer Video Games PC and Video Games, PlayStation 2, PC Games, Xbox, GameCube, Game Boy Advance and PSone