Upgrading SCSM 2012 R2 to 2016 and replace Data Warehouse (server or all)
We're in the planning of upgrading SCSM 2012 R2 to version 2016 including different Cireson products.
Our Data Warehouse Management server is still server 2008 R2 and has an old server name that doesn't match the new naming convention any longer. I know that it's not possible to move the DWH Management server to another server that has a different name, so by upgrading to 2016, I would have to stick to the old name. According to some information, it won't be possible to create a complete new DWH and import all existing data into the new DWH. We need to keep certain information for as long as 10 years. Having 2 different DWH is also not an option.
Does anybody know whether it's possible to insert old DWH data into a new DWH database, contrary to the information I got? Is there possibly another solution to setup a different kind of DWH, import the old data and connect it with the new DWH server? I'm not at all satisfied with the existing SCSM DWH, it's too unstable and needs a lot of effort. SO I'm open for all kind of ideas to upgrade the 2012 R2 environment to 2016 and maybe get a new functioning DWH.
Thanks for your tips.