SQL Server Migration and Upgrade Process
4.6 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
230 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Migration and Upgrade Process to your Wishlist.

Add to Wishlist

SQL Server Migration and Upgrade Process

Migrating databases and upgrading SQL Server versions
4.6 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
230 students enrolled
Created by Raphael Asghar
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Compare to Other SQL Server Courses
Curriculum For This Course
35 Lectures
07:11:24
+
At the end of this course the student will be able to upgrade SQL Server
35 Lectures 07:11:24

2 Why do you want to migrate
11:59

3A Download and install apps
10:00

3B Download and install apps
11:56

4A Configure Domain Controller
10:00

4B Configure Domain Controller
16:03

5A Installing VM for SQL 2012 old system
13:00

5B Installing VM for SQL 2012 old system
12:13

6 Installing SQL 2012
12:24

7 Adding Objects
09:23

8 Reports and packages
09:54

9 Migration options
13:36

10A Gathering task data
13:00

10B Gathering task data
13:43

11A Creating VM for SQL 2016
10:00

11B Creating VM for SQL 2016
14:18

12 Installing SQL 2016
12:52

13 Installing SSMS
10:44

14 SQL 2016 Service pack SP1
12:24

15 SQl Data tools
05:24

16 full backups of source dbs
10:06

17 Data Migration Advisor
19:54

18 Migrate databases
18:58

19 Multiple job alerts operators script out
10:21

20A SSIS and SSRS imports
14:59

20B SSIS and SSRS imports
15:41

21 Deploying reports
09:03

22 Compatibilty issues
11:37

23 Compatibility issues extended
04:33

24 Decommission old database
06:03

25A In place upgrade
15:00

25B In place upgrade
15:49

26A Upgrade to SQL 2016
15:00

26B Upgrade to SQL 2016
17:46

27 Removing old files
12:40
About the Instructor
Raphael Asghar
4.5 Average rating
2,361 Reviews
24,985 Students
13 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.