Migration from 2012R2 to 2016 -Portal "content"

Brian_Wiest

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. 

john_doyle

Hi Brian,

Why don't you just take the existing ServiceManagement database, copy it and then install the new portal against this database? You can run the usual commands from a full resynch if you need to clear old data.

john_doyle

Hi Brian,

Why don't you just take the existing ServiceManagement database, copy it and then install the new portal against this database? You can run the usual commands from a full resynch if you need to clear old data.

john_doyle

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_Wiest

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_Theyssens

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_Wiest

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_Theyssens

Brian,

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

Thanks!

Brian_Wiest

https://support.cireson.com/KnowledgeBase/View/1142#/