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.