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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Restoring a GP Company...
Microsoft Dynamics GP (Archived)

Restoring a GP Company database when using MR's Datamart

(0) ShareShare
ReportReport
Posted on by Lyn Barr 1

I haven't found any information on this, but since MR's datamart uses SQL Server Change Tracking, we have discovered that it is a problem to restore a Dynamics GP Company database, because then the DDM is no longer in sync with the company.

Does anyone know the proper sequence of steps to follow, when restoring a GP database in an environment that is using MR's DDM?

We have been removing the datamart, restoring the company database, and then restoring the datamart.  However, this makes restoring a database much more interruptive than we would like in a production environment, and I am looking for a quicker method.

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    We actually cover this in our new Management Reporter book.  You are following the correct process.  You must delete the old DataMart and create a new one with the data from the restored database.

  • Lyn Barr Profile Picture
    Lyn Barr 1 on at

    Thank you, Richard.  I hate that answer, though!  Thank you again.

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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