| |
| |
|
softwarecatch.com
|
|
|
|
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
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains Customization Tools - Overview Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions Great Plains was initially designed in the earlier 1990th as the extendable and modular application with its proprietary tool: Great Plains Dexterity, written in C programming language as a shell. This was popular tendency those days -compare with SAP ABAP or Navision C/Side. Google Brings the Earth to Your Desktop Google Inc. has launched a new software package that allows you to see satellite images on your desktop. SSH (SCP) Send Files from Windows to Your Linux Box Not all of us have the luxury of working both at home and at work on a UNIX based system. However that doesn't mean you can't transfer files safely and securely between the two systems. Groupware Finds Home in American Business: Collaboration Tool Analysis What is Groupware?Have you ever had to manage document collaboration in a hurry? No need to be ashamed if you said "yes." Virtually every American business has experienced moments of ad hoc team collaboration. Microsoft RMS Customization - PO Items Receiving in Great Plains Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision - Microsoft Business Solutions. There is often common need to do integration between the two. Microsoft Great Plains eCommerce - Stored Procedures Approach Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). 6 Easy Steps for a Smoother CD/DVD Order It's all about turn times in the eMedia industry! The speed with which your vendor can get your CD or DVD project completed is vital to many customers. However, responsibility for these projects meeting their completion dates starts with the customer and ends with the vendor. netstat - Linux Command to Display Networking Information In linux, one of great commands for finding out information about your network connections is "netstat". It provides you interface information, statistics, connections, and a lot of other really great information about your computer. SQL: Querying Microsoft Great Plains - Overview for Database Administrator/Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Manufacturing Solutions for Microsoft Great Plains - Overview for Consultant Microsoft Business Solutions Great Plains has full-featured manufacturing set of modules. In this small article we would like to give you highlights on what kinds of light customization you could deploy, before jumping into Microsoft Great Plains Manufacturing realm. CROOK: A Methodology for the Refinement of Forward-Error Correction Table of Contents1) Introduction 2) Related Work 3) Framework 4) Implementation 5) Performance Results5.1) Hardware and Software Configuration5. Can You Calculate Complex Financial Calculations? Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!)But the hard stuff, you know, the things you need to know when you're running a small business. 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. Groupware: What Works the Way Businesses Do? GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today. C++ Tutorial 1, Introduction to C++ Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. Defining OLAP Solutions and Data Warehouse design This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. The Software 2005 Conference - A Review The Software 2005 conference is now a wrap. This conference, presented by M. Microsoft Great Plains Integration Manager: Using Continuum - Overview for Developer Microsoft Business Solutions Great Plains has I'd say end user integration tool - Great Plains Integration manager. Integration Manager itself uses OLE functionality to validate text or ODBC integration files data through Great Plains forms behind the scenes. Microsoft Great Plains Security Setup - Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise. Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center - overview Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
