Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th ? the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6.5, 7.0 and 2000 ? we see more historical custom projects done in SQL stored procedures and front ends coded in VB in Visual Studio 6.0. This was probably wise and natural choice in that time (around 1997-2001), but if you consider Microsoft move to .Net platform and reshaping its own programming environments (ADO, OLE, VB, etc) ? you would nowadays rather be nervous relying on VB 6.0 custom front end, calling stored procs via ADO. Let's consider your options:

? Upgrade to .Net. As natural it might sound and look, however it might not be feasible. The reason is - .Net is the whole revolution to Windows object model (or its introduction, somewhat more revolutionary, than J2EE/EJB/Java). Your old VB code is not object oriented in the sense of .Net and majority of technologies are now obsolete or in phase out mode

? Move Front End to Web Application. Or recreate simplified version as VB.Net or C#.Net web project. If you think your stored procedures are still capable to do the job at the data manipulation level, you can redesign front end as web application. This is preferred way for now, however as business owner you may not like the idea to redo it.

? Complications. You might have additional complications, such as tiered design, when your presentation layer is separated from business layer (or physically these two layers sit on different computers). Then, somebody should carefully analyze and design the upgrade path for both. Unfortunately business logic level may deploy third party vendors logic, and these flourishing ISV of late 1990th might be now out of business

? Integrations. If your Great Plains is integrated with Unix, Oracle, DB 2, Lotus Domino, Siebel or other third party application ? you need to consider synchronous upgrade for integrated applications to avoid retuning integration piece twice.

? Reporting. Since version 6.0, Great Plains is very conservative to tables structure changes, so if your reporting was done in 1999 or later ? more likely you are out of trouble and should use it as it is.

Happy customizing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.

In The News:

pen paper and inkwell


cat break through


Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

The End of Spyware?

The US House of Representatives has recently passed the "Spy... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More

How to Choose the Right Accounting Software for Your Business

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

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

Logistics automation is often considered as barcoding extension to Sales... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... 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

A Symons Mark II Function Point Counting Example

I provide, here clear explanations and a count of function... Read More

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

My Experience - Making a Vision into Reality

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

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

Basic Steps To Optimize Your Internet Security

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

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

How to Build a Basic CSS Layout

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