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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I copy product...
Microsoft Dynamics GP (Archived)

How can I copy production database to test database

(0) ShareShare
ReportReport
Posted on by manelson05 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

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator 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.

  • 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?

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

    Yes

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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