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

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) / Create test data from ...
Microsoft Dynamics GP (Archived)

Create test data from production GP data

(0) ShareShare
ReportReport
Posted on by Rekha Sharma 175

Hi - I am working with a PSA vendor who integrates with our GP. They have trouble integrating and want to get an backup of our database so they can troubleshoot the problem by configuring their instance like ours. I do not want to give them a backup of our production database for privacy reasons. I just want to give them some test data and our GP  configuration. Is there a tool that can anonymise our production database? 

I do have a test environment of GP but it has production data as well. If there is a utility that can convert  my test environment a  test data instead of real production data, that would be great.

Any idea to achive this would be greatly appreciated.

Thanks,

Rekha

 

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Why not just send them a copy of the Fabrikam database. Depending on what they need to see that may be sufficient. If need be, perhaps you could add GL accounts, vendors, customers and items to Fabrikam to match what you have in production.

  • Rekha Sharma Profile Picture
    Rekha Sharma 175 on at

    It won't take our config - we are using multicurrency and created many custom rate types - the troubleshooting is required on rate type issues we are haibf with the integartion.

    If there was a way to mass delete the data, just keeping the config data only might work as well but not sure how to do that..

  • Community Member Profile Picture
    Community Member on at

    You could use the Copy Company utility in Professional Services Tools Library. This will create an exact copy of your production company - without any transactional data.

    Then manually enter some transactions in the area where they need to test.

    Ian.

  • Rekha Sharma Profile Picture
    Rekha Sharma 175 on at

    Thanks for the direction Ian. But I had no success.

    I installed PSTL and  have two issues.

    1. It asks for "Utilitiy Registration Code" I don't know where to find that.  I went to customer source to check the license key and tried all of them :) but none of the keys worked.  Any idea where I can find the utility registration code?

    2. Without registering, system took me to the next page but but there is no option to copy company (see the attached screen shot). If I am not wrong it is supposed to be under Misc tools.. I am assuming because my registration was not sucessful, I do not see the option??

    I am on GP 10 and trying it in my test environment.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Rekha,

    When you installed the PSTL - the enter PSTL registration code window should have opened...and it should have been pre-filled with a registration key. PSTL is free to use with GP10 and 2010...and the install comes with a default reg code. The reg keys for PSTL are not available on Customersource - they come preloaded in the software install.

    Where did you get the install files for PSTL from?

    The correct install is available on customersource (I believe). If you are having difficulty finding it, contact your partner and they should be able to get it for you. Or PM me and I can see about getting a copy across to you.

    When you insall it - launch each company in turn so that the install can complete for eah company. This is important as it can cause issues for users if you don't.

    Also for installing, you need to be logged in as 'sa'.

    There is documentation on installing on the GP 10 and GP 2010 media.

    Ian.

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    You are using GP 10 so the copy company utility is not available. You can download it from the following link though:

    mbs.microsoft.com/.../automatedsolutionsr10.htm solutions

  • Rekha Sharma Profile Picture
    Rekha Sharma 175 on at

    Thanks Ian - I was able to install PSTL but as Jonathan mentioned Copy functionality is not in the tool. so I installed Copy Company from the link Jonathan gave. Thanks Jonathan.

    I ran the utility to see what functionality it provides but it looks like it just copes data and reports. It didn't have option to copy just the setup. I 'll give a try and see what happens.

    Thanks to you both..

    Rekha

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans