Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

How can I copy production database to test database

Posted on by 660

I am needing to move a copy of our production database to our test databasein GP 10.

I have already made a backup of Dynamics and Production database. I do not remember the proccess on doing this. Our Test environment (database) resides on the same server as our production database.

Thank you

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: How can I copy production database to test database

    Yes

  • manelson05 Profile Picture
    manelson05 660 on at
    Re: How can I copy production database to test database

    I need to bring over the users as well. All I see when I go to test and select Restore is (RestoreDatabase) The To Database is TEST can I then chose source as the Production database?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: How can I copy production database to test database

    If you are going to use the same instance of SQL, you first go into GP Utilities and create the Test company. Then you can take the backup of your production company and do a forced restore over the Test company database that was just created. Do you also need to bring over the users as well? If you are going to use a different instance of SQL follow the steps in TK 878449.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans