Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Complicated Management...
Microsoft Dynamics GP (Archived)

Complicated Management Reporter Migration

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are attempting to perform probably the most complicated Management Reporter migration possible. This includes:

  • Registered company name change.
  • Active Directory domain change.
  • Upgrade from MR 2.1.1028.0 to 2.1.11001.1.
  • New server.

To this point, I have managed to get MR server components installed and updated the SID for one of the users so I can actually log in, but none of the companies are marked as "Already Imported" when I go through the import dialog. How do I connect the databases that have already been imported to the migrated company databases?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Complicated Management Reporter Migration

    In the end, I opened a case with MS on this. You have to import the companies. With the newest rollup, they will come in with dbname-Curr. To move all of the reports associated with the old company across, you run this script:

    declare @company nvarchar(5)

    select @company = '**replace with dbname**'

    Update ControlReport set CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = @company + '-Curr') where CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = @company)

    Update ControlTreeDetail set CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = @company + '-Curr') where CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = @company)

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Complicated Management Reporter Migration

    Paul,

    I am not sure your problem is what I think it is, but I'll take a stab at it anyway. When I first started to deploy MR for clients, I didn't always use the data mart, which means I sometimes used the legacy approach. This approach connected MR directly to the databases, in much the same way FRx worked.

    After figuring out this was not the optimal approach, and that legacy was not going to be supported going forward, I began to use the data mart approach exclusively.  One wrinkle, when moving from legacy to data mart, the company databases did not have identical names.

    At first, I would contact technical support every time I encountered this, or similar problems, and they would help fix the problem with the "Dynamics AX Management Reporter 2012 TDBX Update Diagnostic" tool - pay no attention to the fact it has AX in the name... The tools works for GP and SL as well.

    This tool allows you to make changes to existing Dimensions by processing a TDBX file through the Utility, a bit like PSTL in function only. I would recommend logging a technical support incident, if this sounds like the problem your are facing, if not, sorry to have wasted your time.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Complicated Management Reporter Migration

    I did follow those steps. The last bit is all talking about how to update the Data Mart, but we're using the Legacy Provider. I also read the DynGPDataProvInstGuide.pdf and the MRForDynErpInstGuide.pdf. Neither of them address a scenario in which you have to "map" an existing database using the legacy provider.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Complicated Management Reporter Migration

    Paul -

    Follow this article from Microsoft on how to move MR from server to another.

    support.microsoft.com/.../2744330

    Regards,

    Mike Misera

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans