Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need to Restore Dynami...
Microsoft Dynamics GP (Archived)

Need to Restore Dynamics Database everytime Company Databases are Restored?

(0) ShareShare
ReportReport
Posted on by GPDev 1,755

I have installed GP 2010 to a new server and successfully moved/upgraded our GP 9 databases to GP 2010. Right now, this GP 2010 server is for testing and we are still using GP 9 in production for the next two weeks. The night before we go live with GP 2010 I will need to restore our GP 9 databases again to the GP 2010 server. Do I have to restore the Dynamics database again or can I just restore the GP company databases? During this restore I do not want to lose all of the GP 2010 user roles/tasks I setup.

Thanks,

Greg

*This post is locked for comments

  • GPDev Profile Picture
    GPDev 1,755 on at
    Re: Need to Restore Dynamics Database everytime Company Databases are Restored?

    Richard,

    I checked the Tips and Tricks section of www.accoladepublications.com and did not see a new post for a solution for backing up and restoring security information in the Dynamics db. Just checking to see if you were still planning on putting something together for this.

    Thanks.

  • GPDev Profile Picture
    GPDev 1,755 on at
    Re: Need to Restore Dynamics Database everytime Company Databases are Restored?

    Thanks Richard. I look forward to seeing your solution.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Need to Restore Dynamics Database everytime Company Databases are Restored?

    Give me until tomorrow and I will post a set of tables that hold security.  You can export these tables, perform your restore, then initialize the new tables and import the data.  I will post instructions and the table in the Tips and Tricks section of our web.

  • GPDev Profile Picture
    GPDev 1,755 on at
    Re: Need to Restore Dynamics Database everytime Company Databases are Restored?

    Santosh,

    Thanks for your response. I will make sure to include the Dynamics database in the restore plan when I restore the company databases again to the new server.

    Is there any easy way I can backup/restore the custom security I setup in GP 2010 so when I restore the Dynamics database I do not have to manually recreate my custom Roles and assign them to users? (I am not using the "Transfer Security Data" feature of the upgrade process).

    Victoria Yudin has a SQL script for viewing security resource details (victoriayudin.com/.../sql-view-with-security-resource-details-for-dynamics-gp-10) that I could use to backup this data and then after restoring the Dynamics database I could insert this data directly into the security tables. But I know that its a bad idea to write directly to GP tables with sql so I would rather not go this route.

    For the side-by-side upgrade we are following the KB article 878449 "How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server" and also using the standard GP 2010 installation and upgrade documentation. Are there any other resources you recommend for the upgrade?

    Thanks,

    Greg

  • Verified answer
    Santosh Profile Picture
    Santosh 766 on at
    Re: Need to Restore Dynamics Database everytime Company Databases are Restored?

    Hi Greg,

    Dynamics data store system related information like users and exchange rates. It is better to restore Dynamics database as well with company database so your new environment will be update with latest data.

    I hope you are following process document given by partners/customer source.

    Regards,

    Santosh

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans