• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 2207 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Merge Two SpotlightStatisticsRepository Databases

robert_montgomery
over 5 years ago

When I upgraded Spotlight on SQL Server Enterprise to 12.1, I used the 'Federdated' configuration.  I just upgraded to 12.3 and would like to combine the SpotlightStatisticsRepository database from the 'configuration' and the 'federated' server into one database.  This seems like it would allow the reporting from the new SpotlightStatisticsRepository to contain all the servers being monitored.  Is there a methodology or suggested approach?  

  • 0 over 5 years ago

    Hi Robert,

    It's best to contact our support team if you haven't already done so.

    I would first backup both databases, then add the Repository database data of the federated Diagnostic Server to the Repository database of the configuration Diagnostic Server. Next, use the following steps to update the Diagnostic Server domain IDs of the configuration Diagnostic Server database.

    1.  In SSMS login to instance holding the configuration DS Repository database.

    2.  Under SpotlightStatisticsRespository | Programmability node, execute SP MoveDiagnosticServerHost()
    Enter the input parameter values:
    set @From_Domain = Domain ID of federated Diagnostic Server from step c
    set @To_Domain = Domain ID to configuration Diagnostic Server from step c
    set @FixBug = 0 if the Diagnostic Server port is 3843, otherwise, set to 1

    Gita