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/