At the end of this course the student will be able to upgrade SQL Server
- 1 What is SQL Migration
- 2 Why do you want to migrate
- 3A Download and install apps
- 3B Download and install apps
- 4A Configure Domain Controller
- 4B Configure Domain Controller
- 5A Installing VM for SQL 2012 old system
- 5B Installing VM for SQL 2012 old system
- 6 Installing SQL 2012
- 7 Adding Objects
- 8 Reports and packages
- 9 Migration options
- 10A Gathering task data
- 10B Gathering task data
- 11A Creating VM for SQL 2016
- 11B Creating VM for SQL 2016
- 12 Installing SQL 2016
- 13 Installing SSMS
- 14 SQL 2016 Service pack SP1
- 15 SQl Data tools
- 16 full backups of source dbs
- 17 Data Migration Advisor
- 18 Migrate databases
- 19 Multiple job alerts operators script out
- 20A SSIS and SSRS imports
- 20B SSIS and SSRS imports
- 21 Deploying reports
- 22 Compatibilty issues
- 23 Compatibility issues extended
- 24 Decommission old database
- 25A In place upgrade
- 25B In place upgrade
- 26A Upgrade to SQL 2016
- 26B Upgrade to SQL 2016
- 27 Removing old files
