How do I migrate my pre-defined searches and navigation nodes from one environment to another

Adrian_Paech

Hi,

We are migrating to Prod soon, and I have a bunch of pre-defined searches available to analysts that I would like to migrate from dev to production, along with the navigation node structure I have created.

Is there any way to do this? Can this be done in a similar fashion to migrating the knowledgebase?

e.g.: https://support.cireson.com/KnowledgeBase/View/1341#/

Kind Regards,

Adrian

Adrian_Paech

I managed to migrate by bringing over the entire database, and then re-installing the Cirison Portal via the setup. (which is as per you KB instructions).

This brought over everything, just had to update the licence etc.

Regards,

Adrian

Olivier_Barraud

Hello Adrian,
In case you need it again in the future, or anyone else.
It's held within a combination of three tables: DisplayString, NavigationNode and ViewPanel.
Start with the DisplayString table, DisplayString column, where you'll find your named search.
ElementId in this table is also the Id of the NavigationNode.Id, which you'll also find in the ViewPanel.Definition.
As a way of checking, you could also rely on the combination of CreatedBy+CreatedDate in these three tables, as long as you already have the related user's Id.
Build a query to insert all of these in your new DB and good to go !
The user has to start a new web session to see the inserted searches.
Hope this helps !

Tony_Collett

I've had a look through the ServiceManagement database and I wasn't able to find where the saved searches were located (granted, my database search was brief and not thorough) so at this stage I would say you would need to recreate the searches in the new environment.

I'll continue to have a look when I can and will revise my comment if I find something more substantial

Adrian_Paech

I managed to migrate by bringing over the entire database, and then re-installing the Cirison Portal via the setup. (which is as per you KB instructions).

This brought over everything, just had to update the licence etc.

Regards,

Adrian

Olivier_Barraud

Hello Adrian,
In case you need it again in the future, or anyone else.
It's held within a combination of three tables: DisplayString, NavigationNode and ViewPanel.
Start with the DisplayString table, DisplayString column, where you'll find your named search.
ElementId in this table is also the Id of the NavigationNode.Id, which you'll also find in the ViewPanel.Definition.
As a way of checking, you could also rely on the combination of CreatedBy+CreatedDate in these three tables, as long as you already have the related user's Id.
Build a query to insert all of these in your new DB and good to go !
The user has to start a new web session to see the inserted searches.
Hope this helps !

Adrian_Paech

Thanks for that!

Adrian