Computers, Great Plains Consultant: Moving Dynamics GP to New Server
1. Great Plains on MS SQL Server 2000 (or SQL Server 2005). In the case of being on MS SQL 2000, you need first to understand, that you should move it to exact blend of SQL Server. Especially it is important if you are on version 7.5 or earlier - these versions were sensitive to SQL license. This means that if you are using MSDE, you can't redeploy Great Plains on new server, where you load MS SQL 2000 Standard, for example. If you have SQL DBA in staff - you can ask her or him to simply transfer all the databases, users and security to new server. If you don't have DBA, then you should have your GP consultant to use GP users capture and transfer scripts, available from Microsoft Business Solutions Partner or Customer Source (if you are not current with GP annual enhancement program, likely that your customer source expired too)
2. Great Plains on Ctree. This version is easily transferrable to new server, assuming that you are on GP 7.5 or 7.0. You should install Ctree default GP on the new server and then copy over files from your old server. You will need help with Location Translation, when you first launch Great Plains. You can call us to get this help
3. Great Plains on Pervasive SQL. You should have Pervasive SQL CD, and you install Pervasive server first on the server. If you plan to use GP on Pervasive as Single User Workstation, you do not need to install Pervasive SQL Server there. Then simply repeat steps described in #2
4. Great Plains Standard on MSDE. You follow the same recommendations as in #1, however we recommend you to use Microsoft SQL Server 2000 client tools - SQL Enterprise Manager and Query Analyzer. You can probably do the work with DOS based tools available for MSDE instead, however it is more difficult
Andrew Karasev, Alba Spectrum, LLC, http://www.albaspectum.com, help@albaspectrum.com, 1-866-528-0577, serving Great Plains Dynamics GP community since 1994. Please visit our information portal Pegas Planet: http://www.pegasplanet.com. GP, SAP B1 local service in Chicago, Naperville, San Diego, Atlanta, Houston, Dallas. We specialize in ERP remote support and we cover the whole territory or the USA, Canada, Mexico, Central America, Caribbean, Pacific, UK, Australia, New Zealand. US States covered: IL, CA, FL, WA, DC, NY, MI, PA, AZ, TX, LA, GA, AL, HA, IN, WI, AL, KA, IO, NV, NM, CO, SC, NC, DE, MA.
Related Tags: microsoft, dynamics, gp
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul