SSIS 2016 Session 4 - Migrating SSISDB and SQL Agent Jobs - Hands On Easy Demo!
This Session is not divided into separate parts and should be watch in its entirety because of the strong dependency between each concept that is presented.
( / greg-c-coopman-b07b54103 )
This video presents concepts from the following outline:
Server Environments
On Premise SQL Server (source)
Azure VM SQL Server (target
Projects
Create Project SSISDB Folder
Deploy Packages from Visual Studio
Environments
Script
Add Reference to Project
Map Project Parameters to Environment Variables
Create Service Account
Assign to local databases
Assign Permission and roles in local database
Logins and Permission to External Data Sources
Create Credential
Create SQL Agent Proxy
SQL Agent Jobs
Create Script
Modify Script
Test and Debug