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


Software Engineering: An Introduction

Software Engineering is the Systematic Approach for analysis design implementation... Read More

Is Your Small Business Ready For A CRM Software Solution?

I have yet to see a business that, sometimes in... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Microsoft Great Plains Payroll Module Customization Scenarios

It is now common thing when large corporation selects mid-market... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Microsoft Great Plains Reporting ? Overview for Developer

Looks like Microsoft Great Plains becomes more and more... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

The Dreaded Paper Label - Should it be Used?

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

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

C++ Function Templates

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

3 Reasons Why Medical Billing Software is Leading the Way

Since technology changes so quickly, it is hard to begin... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Navision Attain C/ODBC Crystal Report ? Customization Example

Microsoft Business Solutions Navision is main ERP application for European,... Read More

SyncUp ? A File/Folder Synchronizer For Windows

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

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More