Home Analyst Portal

Migration from 2012R2 to 2016 -Portal "content"

Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
Similar to https://support.cireson.com/KnowledgeBase/View/1341#/ 
I am testing moving from 2012R2 to a 2016 farm. The LifeCycle app was able to do most of the lifting for the console but in my environment we have spent a lot of time with dashboards and the navigation looking if anyone has run thru a process like the KB for moving KB content. 

Best Answer


  • john_doylejohn_doyle Cireson Support Ninja IT Monkey ✭✭✭✭
    Most of the dashboards are stored entirely in the NavigationNode, ViewPanel and DisplayString tables. The out of the box dashboards and nodes are hardcoded, so if your new portal is vanilla and at the same Portal version as the 2012 box, you should be able to simply copy those three tables from the original ServiceManagement database into the new one replacing the existing table content.
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    To confirm @john_doyle there are no schema differences between the 2012 and 2016 in the ServiceManagmenet DB? That one can lift the entire DB into the new SQL instance. Run the truncate commands on the cachbuilder tables and start it up.
  • Filip_TheyssensFilip_Theyssens Partner IT Monkey ✭

    And what should one do if the portal has already been installed using a new database?

    Can I just delete and replace the old database?

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    That is what we did. 
    Deleted the current ServiceMangement DB installed from the 2016 installer
    Stopped the cache builder
    Deleted the DB
    Lift and dropped the Old DB
    Truncated tables that the cache builder builds
    Ran the installer again to make sure the connection strings were in place
    Allow the cache builder to repopulate the truncated tables. 
    This provided us a full replica of the production instance.
  • Filip_TheyssensFilip_Theyssens Partner IT Monkey ✭


    Last question, using which commands did you truncate which tables?


Sign In or Register to comment.