Have a button to run a bunch of extentions at one time

Something that takes report of what i want extendend then does this

• Run SQL as Administrator, and connect to iChannel server
  1. Optionally, open SQL on iChannel as “iChannel” user
• Navigate to database cadoc_Ext
• Right-click on database, and select “tasks”, and then “Export Data”
• Change data source to SQL Server Native Client, 11.0
  1. Leave server name, iChannel, and leave database cadoc_Ext
• Change destination to SQL Server Native Client, 11.0
  1. Enter “ichannel” as server, and select cadoc_Ext as database
  2. Click Next
• Leave default option selected: “Copy data from one or more tables or views”, click Next
• Locate dbo.tTaskDeliverable table, and adjust destination name to include date, time, and initials.
  1. Format is generally 20190314_1025_Backup_MH_tTaskDeliverable
  2. Click Next
• Leave “Run Immediately” checked, click Finish, and then click Finish again
• Refresh view in SQL, and you should see another table with the backup name listed. Confirm this is completed before moving forward. If you do not see the backup table, do not move forward with the next steps.
• Open “New Query” window, and perform a select on the data that you will be updating.
  1. Example of query is:

SELECT *

FROM [cadoc_Ext].[dbo].[tTaskDeliverable] with (nolock)

where nid in ('12345’,’67890’)

1. Tip: You may use notepad ++ to convert list in Excel to this format, by running a replace and including expanded characters. The key is to reply “\r\n” with “ ’,’ ” to give you the format you need.

• Ensure results match expected, and that dates in the dWFCurrDueDate column represent values that you are expecting to be extended
• Adjust query to perform update if values are expected
  1. Example of query is:

update [cadoc_Ext].[dbo].[tTaskDeliverable]

set dWFCurrDueDate = '10/15/2019'

where nid in (‘12345’,’67890')

1. Tip: You may want to open a “New Query” window, and perform update in new tab, so that you can switch back to select and confirm records have changed as you expected

• Update documentation from Admin to reflect changes have been confirmed to records that you have worked on.