SQL Server Migration and Upgrade Process

Name: SQL Server Migration and Upgrade Process
Rating: 4.5 (926 reviews)

Migrating databases and upgrading SQL Server versions

Created byRaphael Asghar

Last updated 6/2020

English

What you'll learn

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 content

1 section • 35 lectures • 7h 11m total length

1 What is SQL Migration11:01
2 Why do you want to migrate11:59
3A Download and install apps10:00
3B Download and install apps11:56
4A Configure Domain Controller10:00
4B Configure Domain Controller16:03
Prepare a domain controller and active directory environment, assign a static IP, create domain users, and set up a virtualized SQL Server 2012 migration on a VirtualBox setup.
5A Installing VM for SQL 2012 old system13:00
5B Installing VM for SQL 2012 old system12:13
6 Installing SQL 201212:24
7 Adding Objects9:23
8 Reports and packages9:54
9 Migration options13:36
10A Gathering task data13:00
10B Gathering task data13:43
11A Creating VM for SQL 201610:00
11B Creating VM for SQL 201614:18
12 Installing SQL 201612:52
13 Installing SSMS10:44
14 SQL 2016 Service pack SP112:24
15 SQl Data tools5:24
16 full backups of source dbs10:06
17 Data Migration Advisor19:54
18 Migrate databases18:58
19 Multiple job alerts operators script out10:21
20A SSIS and SSRS imports14:59
20B SSIS and SSRS imports15:41
21 Deploying reports9:03
22 Compatibilty issues11:37
23 Compatibility issues extended4:33
24 Decommission old database6:03
25A In place upgrade15:00
25B In place upgrade15:49
26A Upgrade to SQL 201615:00
26B Upgrade to SQL 201617:46
27 Removing old files12:40

Requirements

The requsites for this course are: SQL Admin part 1,2,3, Learn TSQL From Scratch. SSRS and SSIS. A desktop or a laptop. All other material will be provided via 180 days trial period apps

Description

The primary goal of this course is to give the studentreal life step by step procedures, documentation, insights and navigate him/herthrough the setting up and configuring of SQL Server migration and upgradeprocess from the old version of SQL Server to the latest version ofSQL Server. With detailed explanation and examples, the student will beable to apply what he has learned into the real world. This coursecan be applied to SQL versions 2008, 2012, 2014.

Who this course is for:

Any student, IT staff member, developer, junior dbas or person that wants to understand the procedures in migrating and upgrading an older version of SQL Server to the latest version of SQL Server