web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Transferring data from...
Microsoft Dynamics GP (Archived)

Transferring data from one database to another

(0) ShareShare
ReportReport
Posted on by Community Member

What is the best way for me to transfer all my information in dynamics GP from one database to another. And, how do I do it?

We have one separate company in XYZ database and need to move it to ABC database. What are all the steps that needs to be taken into consideration?

Thank you.

*This post is locked for comments

I have the same question (0)
  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Are you referring to just setup information and master records?  If so, see these two kb articles.  The first one lists many of the main setup setup and master record tables; the second one walks you through to copy the tables from one db to another.  Of course, make sure you have good backups of both databases, prior to doing any of the work.

    support.microsoft.com/.../872709

    support.microsoft.com/.../874208

  • Community Member Profile Picture
    Community Member on at

    Would the process be the same for GP2013 and SQL2012?

    Thanks.

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Yes, for SQL it should be the same.  There may be a couple of additional tables in GP 2013 depending on what all you are trying to copy over but the list from the first article will cover the majority of them for sure.

  • WindyCityGP Profile Picture
    WindyCityGP 1,069 on at

    You could also use the "Company Copy" utility if you have the Professional Services Tools Library installed (available for free from your partner).

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans