| Home | Free Articles for Your Site | Submit an Article | Advertise | Link to Us | Search | Contact Us |
This site is an archive of old articles

    SEARCH ARTICLES
    Custom Search


vertical line

Article Surfing Archive



Microsoft Great Plains migration from one SQL Server to another * overview for consultant - Articles Surfing

Microsoft Great Plains has tens thousands of installation across the USA as well as in Australia, New Zealand, Spanish speaking South America, UK, Poland, Middle East and South Africa. It is on the market since 1994 when Great Plains Software released its Graphical Mac and Windows based Accounting system * Great Plains Dynamics. Now, in post-recession time we see thousands of clients world-wide are without support or as Microsoft Business Solutions names them * orphan clients. Our goal here is to educate IT department or general IT consultants to self-support Microsoft Great Plains. Today's topic is how to move Microsoft Great Plains (old names * Dynamics and eEnterprise) from one Microsoft SQL Server to another.

1. Microsoft Great Plains security model * currently Great Plains has user IDs stored in Great Plains tables as well as on the level of Microsoft SQL Server 2000 (or 7.0). Look at the Logins for the SQL Server, hosting Great Plains * you will figure out that all the GP users are Logins. And they are stored in Master database. Now if you look at Company database (TWO database, for example) * you will find users on the database level * these users have the same names as logins on the system level, plus you will find DYNGRP * this is the role on the company database level.

2. Security Migration * now you see that if you just install SQL Server on the second computer and restore DYNAMICS and company databases from their backup * SQL Server system logins and their security will be lacking. If you feel comfortable being MS SQL DBA * you are good to use MS SQL Server Data Transformation Services to import security information from the old server. If not * then you need to use confidential (you should have Microsoft Business Solutions annual support plan) scripts to migrate Great Plains security information or call Microsoft Great Plains consultant.

3. Recommended Steps * We recommend you to install MS SQL Server, then install exactly the same Great Plains environment with the same companies IDs and GL account segment structure/sorting (empty companies). At this point you are ready to restore DYNAMICS and all companies from their backups * do it. And finally * you need to transfer security * if you want DTS way * go ahead * should work. If you are not comfortable with DTS and have MBS support, login to Microsoft Business Solutions customer support section and find techknowledge #878449: *How to transfer Great Plains and Microsoft SQL Server 7.0 or SQL Server 2000 to a new server* with capture_logins, drop_users_dynamics and other scripts and follow the instructions

Happy migrating! if you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

Submitted by:

Andrew Karasev

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies * USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Microsoft Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com



        RELATED SITES






https://articlesurfing.org/computers_and_internet/microsoft_great_plains_migration_from_one_sql_server_to_another___overview_for_consultant.html

Copyright © 1995 - Photius Coutsoukis (All Rights Reserved).










ARTICLE CATEGORIES

Aging
Arts and Crafts
Auto and Trucks
Automotive
Business
Business and Finance
Cancer Survival
Career
Classifieds
Computers and Internet
Computers and Technology
Cooking
Culture
Education
Education #2
Entertainment
Etiquette
Family
Finances
Food and Drink
Food and Drink B
Gadgets and Gizmos
Gardening
Health
Hobbies
Home Improvement
Home Management
Humor
Internet
Jobs
Kids and Teens
Learning Languages
Leadership
Legal
Legal B
Marketing
Marketing B
Medical Business
Medicines and Remedies
Music and Movies
Online Business
Opinions
Parenting
Parenting B
Pets
Pets and Animals
Poetry
Politics
Politics and Government
Real Estate
Recreation
Recreation and Sports
Science
Self Help
Self Improvement
Short Stories
Site Promotion
Society
Sports
Travel and Leisure
Travel Part B
Web Development
Wellness, Fitness and Diet
World Affairs
Writing
Writing B