Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Procedure to copy live data to test company

Posted on by Microsoft Employee

Looking for something official - procedure to copy live GP 2015 data to the test company.  (not a separate instance of GP)  

*This post is locked for comments

  • Don Wisch Profile Picture
    Don Wisch 660 on at
    RE: Procedure to copy live data to test company

    Angel is right and I use that link all the time BUT for IINTERID's the script they show in the article does not apply for GP 2013 and further since now you have the option to create multiple DYNAMICS databases so this changes things a bit.  This really means there is a new table SY00100 found in the company database.  Dynamics GP 2013 introduced the option for named system databases. The DBNAME value being updated within the SY00100 must be the name of your system database - for example DYNAMICS.

    To resolve this, look at this article from MS
    https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyqlytnsukzpxkmunvqpuupouzqqtvtyuz

    Hope this helps :)

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procedure to copy live data to test company

    THAT'S IT!  I couldn't find anything on how to change the company ID info.  I knew that it wasn't just a simple copy.

    Thank you so very much!

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: Procedure to copy live data to test company

    Try this one:

    support.microsoft.com/.../871973

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans