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
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
