Skip to main content

Notifications

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) / Converting test databa...
Microsoft Dynamics GP (Archived)

Converting test database to production

(0) ShareShare
ReportReport
Posted on by Community Member

I would like to know how to and what is the safest way to convert a test database (company) into a production one.  For example, we are working on a test "T155 - Company A" with database name "T155".  With everything is working well so far now, I would like to know if there is a safest way to convert:

Test database "T155 - Company A" with database name "T155"

into

Production database "S155 - Production Company A" with database name "S155"

Please advise.  Thanks.

*This post is locked for comments

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Converting test database to production

    You can try

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    You also want to run the GRANT.SQL scripts against the production database.

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Converting test database to production

    Hi kt013,

    Grab a trial version of GP Power Tools (GPPT) from the Mekorma site.. The database Validation tool inside of GPPT will help you fix all the inconsistencies related to the copy of one company DB into another one..

    https://winthropdc.wordpress.com/gp-power-tools-portal/

    your issues are most likely related to permissions at the SQL level..

    For your SSRS problems, did you re-deploy the out-of-the-box SSRS reports within GP for the newly created company ?  Have a look at those links for SSRS in Dynamics GP :

    https://www.microsoft.com/en-us/download/details.aspx?id=36075

    https://www.gpug.com/blogs/amy-coddington/2015/09/25/ssrs-security-deployment-and-configuring-ssg-gp-tips

    https://www.gpug.com/blogs/amy-coddington/2015/09/25/ssrs-security-deployment-and-configuring-ssg-gp-tips

    https://www.gpug.com/blogs/amy-coddington/2015/09/25/ssrs-security-deployment-and-configuring-ssg-gp-tips

    Hope this helps..

  • Community Member Profile Picture
    Community Member on at
    RE: Converting test database to production

    Thanks, Richard.  I found those and went on to finish the steps... it took about 6+ hours to finish... and still can't view the reports site for all companies.  Users also start having errors like "A get/change operation on table ‘SY_Current_Activity failed. A record was already locked.", "Error registering table glTaxWork", etc.  Appreciate your help.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Converting test database to production

    Do you have the Dynamics GP Starter or Extended pack? You can login into CustomerSource to found that out. You can also look at your DYNAMICS.SET to find out what modules were installed. That will be in your C:\Microsoft Dynamics\GPXXXX folder. Finally, if you go to Tools->Setup->System->Registration you can see which modules were turned on.

  • Community Member Profile Picture
    Community Member on at
    RE: Converting test database to production

    Thank you, Richard.  I am able to follow the steps toward the end, and am now stuck at where I need to select the MS Dynamics GP products within the Database Maintenance window (step #8).  How do I find out what products I have?  Thanks.  --Khang

    Also - my SQL Server Reporting Services site doesn't seem to work anymore.  It gives User 'domain\user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Converting test database to production

    Depending on which version of GP you are running you may need to run a script.

    support.microsoft.com/.../set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microsoft-dynamics-gp-by-using-microsoft-sql-server

    This script will help. You will need to use SSMS to restore the test database over the production database. The script is run after the restore is done.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans