Course 11: SQL Server Migration and Upgrade
4 STUDENTS ENROLLED
At the end of this course, the student will be versed in how to migrate and older version of SQL server to a newer version of SQL Server and be able to gather the necessary information that is needed for a successful upgrade.
Course Curriculum
1. SQL Server Migration and Upgrade Documentation | |||
SQL Server Migration – Documentation | 00:00:00 | ||
2. What is SQL Migration | |||
What is SQL Migration | 00:00:00 | ||
3. Why do You want to Migrate | |||
Why do You want to Migrate | 00:00:00 | ||
4. Download and Install Apps | |||
Download and Install Apps | 00:00:00 | ||
5. Download and Install Apps | |||
Download and Install Apps | 00:00:00 | ||
6. Configure Domain Controller | |||
Configure Domain Controller | 00:00:00 | ||
7. Configure Domain Controller | |||
Configure Domain Controller | 00:00:00 | ||
8. Installing VM for SQL 2012 Old System | |||
Installing VM for SQL 2012 Old System | 00:00:00 | ||
9. Installing VM for SQL 2012 Old System | |||
Installing VM for SQL 2012 old System | 00:00:00 | ||
10. Installing SQL 2012 | |||
Installing SQL 2012 | 00:00:00 | ||
11. Adding Objects | |||
Adding Objects | 00:00:00 | ||
12. Reports and Packages | |||
Reports and packages | 00:00:00 | ||
13. Migration Options | |||
Migration options | 00:00:00 | ||
14. Gathering Task Data | |||
Gathering Task Data | 00:00:00 | ||
15. Gathering Task Data | |||
Gathering task Data | 00:00:00 | ||
16. Creating VM for SQL 2016 | |||
Creating VM for SQL 2016 | 00:00:00 | ||
17. Creating VM for SQL 2016 | |||
Creating VM for SQL 2016 | 00:00:00 | ||
18. Installing SQL 2016 | |||
Installing SQL 2016 | 00:00:00 | ||
19. Installing SSMS | |||
Installing SSMS | 00:00:00 | ||
20. SQL 2016 Service pack SP1 | |||
SQL 2016 Service pack SP1 | 00:00:00 | ||
21. SQl Data Tools | |||
SQl Data Tools | 00:00:00 | ||
22. Full Backups of Source dbs | |||
Full Backups of Source dbs | 00:00:00 | ||
23. Data Migration Advisor | |||
Data Migration Advisor | 00:00:00 | ||
24. Migrate Databases | |||
Migrate Databases | 00:00:00 | ||
25. Multiple Job Alerts Operators Script Out | |||
Multiple Job Alerts Operators Script Out | 00:00:00 | ||
26. SSIS and SSRS Imports | |||
SSIS and SSRS Imports | 00:00:00 | ||
27. SSIS and SSRS Imports | |||
SSIS and SSRS imports | 00:00:00 | ||
28. Deploying Reports | |||
Deploying Reports | 00:00:00 | ||
29. Compatibilty Issues | |||
Compatibilty Issues | 00:00:00 | ||
30. Compatibility Issues Extended | |||
Compatibility Issues Extended | 00:00:00 | ||
31. Decomission Old Database | |||
Decomission Old Database | 00:00:00 | ||
32. In place Upgrade | |||
In place Upgrade | 00:00:00 | ||
33. In place Upgrade | |||
In place upgrade | 00:00:00 | ||
34. Upgrade to SQL 2016 | |||
Upgrade to SQL 2016 | 00:00:00 | ||
35. Upgrade to SQL 2016 | |||
Upgrade to SQL 2016 | 00:00:00 | ||
36. Removing Old Files | |||
Removing Old Files | 00:00:00 |