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
|
|
|
Vlans
In order to implement VLANs in a network environment, you'll need a Layer 2 switch that supports them. Almost all switches sold today that are described as "managed" switches provide the ability to make ports members of different VLANs. However, switches ...(related: Software)
Microsoft Crm Implementation & Remote Support
We would like to give you pluses and minuses of Microsoft CRM.
Two Reasons To Use Timesheet Software
This short paper will expand on two key reasons to move to a computerized timesheet system at your company. There are more than two reasons of course, but these will be expanded on at a later date. The two key reasons to be discussed here are Timesheet E...(related: Software)
A Symons Mark Ii Function Point Counting Example
I provide, here clear explanations and a count of function points, using the Symons Mark II method.We start by identifying the subprocesses (entry, exit, read, write) for each functional process; The size of a functional process is the sum of its data movements (entry, exit, read, write) and the size of a piece of software is the sum of the sizes of all of its functional processes.So the Function Point Index (FPI) for an application is:FPI = Wi * SNi + We * SNe + Wo * SNo,where ‘S‘ means the sum over all Logical Transactions, and the industry average weights per Input Data Element Type, Data Entity Type Reference and Output DataElement Type are, respectively:Now here is an example of this in practise, intended to demonstrate the practicalities of performing the count, see the Simmons counting point manual (...(related: Software)
Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight
Microsoft Business Solutions Great Plains has many years of successful implementation in multiple horizontal markets. In today's small article we'll share our experience of implementing and customizing Microsoft Great Plains, formerly Great Plains eEnterprise/Dynamics in beverage production and distribution industries. These examples will cover two scenarios: US regional distribution and International fruit punch production and sales in US, Latin America and Europe. We'll try to be industry specific and at the same time technical ? using Microsoft Great Plains technical...(related: Software)
Review Of Tikiwiki Content Management System
TikiWiki is open source software - it is written in PHP, uses phpAdmin for mySQL database administration, and uses the Smarty Template Engine.Installation - Since our host installed the TikiWiki, I cannot comment on ease of installation.While TikiWiki has many features, only t...(related: Software)
The Top 5 Wrong Reasons For Not Hiring Testers
Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.We Have a Beta ProgramSome people feel that the best way to debug a system is to ship it to your customers and wait for trouble tickets. I don't know how things work in your industry, but as far as I'm concerned, finding new customers is hard enough. I definitely don't want to make matters worse by shipping them buggy software.I've spent the last 5 years in the telecommunications industry where the standard for reliability is 5-9. If I even suggested to my custom...(related: Software)
Microsoft Crm Customization ? Programming Closed Email Activity
Microsoft CRM is CRM answer from Microsoft and attempt to get market share from Siebel, Oracle and others traditional Client Relationship Management System vendors. Microsoft CRM uses all the spectrum of Microsoft recent technologies: .Net, MS Excha...(related: Software)
Microsoft Crm Customization
Microsoft CRM customization techniques are very diversified and based on the whole spectrum of recent Microsoft technologies. The main terms you should know are: Microsoft CRM SDK 1.2 and Visual Studio.Net 2003. And of course you should be familiar with all the legacy internet technologies, such as HTML, XML, XSLT, JavaScript and be good C#/VB/Net developer.If you are developer who is asked: how d...(related: Software)
New Web-based Hr Tool Is Max From Nas, Hannibal, And Infolink
Three highly respected names in Human Resources have joined forces to provide companies with a revolutionary blend of services that make the hiring process more efficient a...(related: Software)
Microsoft Crm Modification ? Overview For It Specialist
Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision.If you are programmer or database administrator who is asked: how do we modify Microsoft CRM ? read this article and you will have the clues for further research.1. Microsoft CRM SDK ? this is software development kit with C# and partly VB.net code samples ? i...(related: Software)
How To Make Attractive And Effective Powerpoint Presentations
Microsoft PowerPoint has dramatically changed the way in which academic and business presentations are made. This article outlines few tips on making more effective and attractive PowerPoint presentations.THE TEXT
- Keep the wording clear and simple. Use active, visual language. Cut unnecessary words ? a good rule of thumb is to cut paragraphs down to sentences, sentences into phrases, and phrases into key words.
- Limit the number of words and lines per slide. Try the Rule of Five - five words per line, five lines per slide. If too much text appears on one slide, us...(related: Software)
Reporting For Microsoft Great Plains/dynamics/eenterprise: Rw ? Reportwriter ? Tips For Developer
Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexteri...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software