Moving a User table into a Corporate schema v2.0

GIS Admin users will be able to transfer tables from the 'staging' schema to a 'corporate' schema.

Open Studio

  1. Expand the Jobs node, right click on Unassigned tasks and select New Task.
     
  2. Create a Workflow Stored Procedure Task and give it a Name e.g. SDW Move table form staging to corporate
     
  3. Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_move_tableFrom v6.0.0 select astun from the Function filter and pick sdw_move_table.

  4. Select the schemasource parameter and set it to staging by typing in the Edit parameter 'schemasource' box. Repeat for schemadestination (the schema where you want the table moved to) and tablename (the name of table to be moved). From v6.0.0 there is an additional parameter dropifpresent. Set this to true to drop any existing table or leave blank or false to not drop the table..


  5. Click the Run button  to run the task. You should see the dialog SPTask 'SDW Move table from staging to corporate' completed successfully. Click OK.
     
  6. Click Save to save your new task details.