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.