Move Dynamics GP to another server.

We have a Dynamics GP implementation that we would like to copy to another server.  Copying the sql database is easy enough but how do I copy the custom forms and triggers on the GP server?  These are Dexterity forms.  Is it just a matter of moving the .dic files?
LVL 11
b_levittAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James GlaubigerCo-FounderCommented:
If you have access to Microsoft Customer Source you will want to look at the following KB article for step by step detailed instructions: "How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server"   KB 878449

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYQLYTNSUKZPXKMUNVMKVZZXSTSMYWUNMYPOYXKYTZNUXNLSMK

The basic steps are:

1) Backup all databases on old server (DYNAMICS, Company db's)

2) Export user accounts from Master db using script provided in KB article Capture_Logins.sql

3) Export all SQL Server Agent Jobs and Operators

4) Move backups, exports, and Reports.dic, Forms.dic to your new server

5) Install SQL and GP onto the new server (remember to apply all the same service packs to GP that you had installed on the old server)

6) Restore databases from backups

7) Run exported scripts to restore your user accounts, jobs and operators

8) Run the Dex_Req.sql script against the Master database. Run the Grant.sql script against the Dynamics database and against all company databases.  (these scripts can be found in the KB article or in the GP Code Folder\SQL\Util directory)

9) Run sp_changedbowner on all restored databases setting owner to "dynsa" account

10) Place your Reports.dic and Forms.dic into the correct location (which may be a UNC network share) and remap Dynamics.set to point to these files)

11) Make sure you have your ODBC setup to point to the instance of SQL for GP

12) Login to GP Utilities to make sure everything is working correctly, then launch into GP if no errors.


good luck.  If you run into any issues post back here.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
b_levittAuthor Commented:
This pretty much did it.  Thanks opster.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Tax / Financial Software

From novice to tech pro — start learning today.