6 Replies Latest reply on Sep 25, 2019 12:44 PM by cpriddy

    Merging/Joining 2 DPA Repositories

    aiglee.castillo

      Hi,

       

      We have 2 servers with 2 DPA installations and 2 repositories, one of them internally and the other one in an Azure server. We want to migrate the internal one to the Azure server and we want to be able to monitor all of DBs (over 20) from the same DPA installation that is already in the Azure server.

       

      I have moved DPA repositories before, but I'm not sure if we can join 2 DPA repositories. If we can't join the 2 DBs, then we would lose the monitoring history from either most of the DBs or the most important DB, which would be a big loss. Is there any way to either join both repositories or export the history of the DBs that we will move so we can import it again?

       

      Thank you

        • Re: Merging/Joining 2 DPA Repositories
          cpriddy

          I'm not sure of merging the data and how complicated it might be (e.g., export only a subset of repo tables and whether assigned ids, etc. may have to be massaged to match the Azure).

          A couple of alternatives you might want to consider:

          1. Keep the on-premises DPA server around for as long as you are interested in its history. Then configure your Azure DPA Server to function as a DPA Central so that you can reference the historical information from your on-prem Azure DPA.
          2. If you don't plan on using the history often, migrate the on-premises DPA repo and import it into a separate database in your Azure Repo instance. Then when you want to access it, launch a 2nd DPA Server, disable collection, view history, and shutdown the 2nd instance.
          3. Export/import the on-premises data into a separate database and create queries or reports against it and/or create views that union the active and archived data together.
            • Re: Merging/Joining 2 DPA Repositories
              aiglee.castillo

              Thanks for the options!

               

              Regarding DPA Central, can it be done by still moving the on-premise DPA to Azure but have 2 separate Azure repositories? I read that DPA central uses the server information to connect so I dont know if we can have the 2 DPA instances in one server and connect them through DPA Central.

                • Re: Merging/Joining 2 DPA Repositories
                  cpriddy

                  You'll need two DPA Servers, one for each repository (new Azure and moved). As far as running both DPA Servers simultaneously on the same OS, I wouldn't suggest it. The overhead of the second server in terms of resource conflicts will likely impact the scalability (i.e., how many DB instances you can monitor) of the actively monitoring one. I don't know if others have run two servers simultaneously on the same OS and if so, what adjustments or configurations (such as using different ports for each) would be required.

                  My suggestion would be to isolate the second DPA Server into its own VM to avoid same OS resource conflicts and also make it very easy to start/stop when you need it, move it elsewhere, provision resources, avoid difficulties in upgrades, or delete the second server via VM management interfaces.

                • Re: Merging/Joining 2 DPA Repositories
                  cpriddy

                  I confirmed that merging will be difficult because of DPA Server generated names, ids that would likely conflict between the two DPA Server databases. Doing so will require a lot of manual, custom work to resolve and maintain data integrity.

                    • Re: Merging/Joining 2 DPA Repositories
                      aiglee.castillo

                      Awesome! Thank you for all the information. I think we are really tending to DPA Central, just need to confirm resourcing in general.

                       

                      The idea now is that since we are going to continue to grow, instead of just using the "moved" instance as history, we would keep both active and be able to just keep growing.

                       

                      Thank you!

                        • Re: Merging/Joining 2 DPA Repositories
                          cpriddy

                          RE:

                          • Regarding DPA Central, can it be done by still moving the on-premise DPA to Azure but have 2 separate Azure repositories? I read that DPA central uses the server information to connect so I dont know if we can have the 2 DPA instances in one server and connect them through DPA Central.

                          You can have 2 DPA servers running on one OS in Azure, but make sure the OS is Linux. Could potentially use Windows, but it is much more difficult especially on upgrades. Overall, I would still recommend separate VMs to avoid some of the problems mentioned in my earlier response.