Moving View from Staging to Corporate schema V1.5

  • Open Studio
  • Expand the Jobs node, right click on Unassigned tasks and select New Task.
  • Right click on Unassigned tasks and select New Task.
  • Create a Workflow Stored Procedure Task and give it a Name e.g. Transfer View from staging to corporate
  • Select the Spatial Data Warehouse Connection, Click on the Astun radio button and select the Function at_sdw_move_view.
  • Select the tablename parameter and enter the name of the view you wish to move in the Edit parameter box. 
  • Now select the schemaname parameter and enter the name of the destination schema you wish to transfer to e.g.

.

  • Run the task.  Click OK
  • Check in pgAdmin III to see if the View has been created.