1 Reply Latest reply on Jun 29, 2009 8:56 AM by Yann

    exporting views

    Wallaby_Jones

      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

        • Re: exporting views
          Yann

          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