Announcements
Hi All,
We have Management Reporter 2012 application installed on SQL ServerA and Management Reporter Data Mart database [ManagementReporterDM] installed on SQL ServerB.
Everything is working fine.
But ServerB is AX prod Server and Management Reporter is causing issue to MS Dynamics AX DB and we are planning to migrate DB [ManagementReporterDM] to ServerA.
Option-1: Create DB [ManagementReporterDM] on ServerA and rebuild it. We have done this couple of times but we know this takes longer time more than 3-4 days to rebuild and want to avoid. www.gpug.com/.../management-reporter-rebuilding-your-data-mart.
Option-2: Backup and restore [ManagementReporterDM] from ServerB to ServerA and then re-point [ManagementReporter] connections to [ManagementReporterDM]. How to do this..? Has anyone done this before.? How many places we have to update connections..? we have never done this and not sure it will work or not..?
If I update new connection for column [Settings] in [ManagementReporter].[Connector].[MapCategoryAdapterSettings], will work..?
SELECT [Id],
[TaskCategoryId],
[RowNumber],
[AdapterId],
CAST(REPLACE(CAST([Settings] AS VARCHAR(MAX)), 'Old_Server', 'New_server') AS XML) [Settings],
[SettingsHash],
[Version]
FROM [ManagementReporter].[Connector].[MapCategoryAdapterSettings]
Gurus, Please help.
https://www.youtube.com/watch?v=rb5viBSpD-k
http://yetanotherdynamicsaxblog.blogspot.com/2014/09/installing-management-reporter-2012-for.html
https://opalbiz.com/dynamics-gp/migrating-management-reporter-database-to-new-sql-server/
Hello,
I would strongly recommend that you rebuild the Data Mart. Microsoft does not recommend that you move the Data Mart as that will just cause a lot more issues for you.
Thank you,
Erik Johnson
Microsoft
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156