Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dynamics GP 2013 - setup 2 Dynamics databases to run from 1 GP Install

(0) ShareShare
ReportReport
Posted on by

Hi Everyone

1 have a company that merged.

I have  company 1 and the

merged company running on Server 1  

 SQL 2012 with GP 2013

Company 2 running on Server 2

MS SQL 2008 R2  with GP 2010

I would like to upgrade Company 2 to GP 2013 and have  users use  from the single copy of GP 2013 installed on there local work stations.

or is there a way to export the data and import it to server 1  - the database will only be used to lookup information

*This post is locked for comments

  • Lyn Barr Profile Picture
    on at
    RE: Dynamics GP 2013 - setup 2 Dynamics databases to run from 1 GP Install

    These steps are very general, and I strongly urge you to reach out to your Microsoft partner for assistance.  There may be a more efficient method, but this method should do the trick:

    Preliminary: backup-backup-backup-backup. On both servers!

    Also, is your account framework the same, in both instances of GP?  If not, these steps will probably fail.

    On Server 1, backup the 2013 DYNAMICS database.

    On Server 2, you may need a service pack prior to being able to upgrade, so check the upgrade path (requires CustomerSource login): mbs.microsoft.com/.../HOT_TOPIC_MDGP2015Upgrade

    On Server 2, backup BOTH the DYNAMICS and your COMPANY database

    Restore these backups onto Server 1 - Make sure you have that backup of your original Server 1 DYNAMICS, first!

    On Server 1, launch GP Utilities. It should see the one database, and prompt you to upgrade it.

    Once the upgrade is complete, backup that upgraded database.

    On Server 1, restore the original DYNAMICS database, then launch GP Utilities and create a new company. This will be your permanent company for the upgraded database, so choose a name that makes sense.

    On Server 1, restore the backup of the upgraded database into the new, permanent company.  Then, you can drop the upgraded database, if you like.

    That should do it!  Also, please note, I can't take credit for these steps! Our upgrade guru, Alicia Patton, came up with this process!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans