cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

exporting views

Is it  possible to export the views that you have created in an orion server to a different orion server?

 

If so how can it be done?

 

Jeff

Tags (1)
0 Kudos
1 Reply
Level 15

Hi Jeff,

There is no utility for this.

A solution would be to export the settings of your views using SQL Server Import/Export Wizard.

http://msdn.microsoft.com/en-us/library/ms141209.aspx

Settings are stored in the following tables:

Views

Resources

ResourceProperties

 

Ensure you do not overwrite existing settings on the remote database as IDs are likely to be the same in both DB.

Edit the ViewID in Views and Resources tables before to import data in the database so that it uses IDs not existing on the destination database.

Please try the above on testing environment replicating the production environment before to touch your production servers to ensure the procedure is working.

HTH,

Yann