Moving a View from the Staging to a Corporate schema v2.0

Open Studio

1. Expand the Jobs node, right click on Unassigned tasks and select New Task.
    
2. Right click on Unassigned tasks and select New Task.
    
3. Create a Workflow Stored Procedure Task and give it a Name e.g. Transfer View from staging to corporate
    
4. Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_move_view. From v6.0.0 select astun from the Function filter and pick sdw_move_view. 
   .
5. Select the viewname 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.
   .
6. Click the Run button  to run the task. You should see the dialog SPTask 'Transfer View from staging to corporate' completed successfully. Click OK.
   
   
7. Click Save to save your new task details.
   
   
8. Check in pgAdmin III to see if the view has been moved.