SQL Server Migration and Upgrade Process

SQL Server Migration and Upgrade Process, available at $69.99, has an average rating of 4.62, with 35 lectures, based on 746 reviews, and has 4134 subscribers.

You will learn about 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 This course is ideal for individuals who are 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 It is particularly useful 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.

Enroll now: SQL Server Migration and Upgrade Process

Summary

Title: SQL Server Migration and Upgrade Process

Price: $69.99

Average Rating: 4.62

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: At the end of this course the student will be able to upgrade SQL Server

Lecture 1: 1 What is SQL Migration

Lecture 2: 2 Why do you want to migrate

Lecture 3: 3A Download and install apps

Lecture 4: 3B Download and install apps

Lecture 5: 4A Configure Domain Controller

Lecture 6: 4B Configure Domain Controller

Lecture 7: 5A Installing VM for SQL 2012 old system

Lecture 8: 5B Installing VM for SQL 2012 old system

Lecture 9: 6 Installing SQL 2012

Lecture 10: 7 Adding Objects

Lecture 11: 8 Reports and packages

Lecture 12: 9 Migration options

Lecture 13: 10A Gathering task data

Lecture 14: 10B Gathering task data

Lecture 15: 11A Creating VM for SQL 2016

Lecture 16: 11B Creating VM for SQL 2016

Lecture 17: 12 Installing SQL 2016

Lecture 18: 13 Installing SSMS

Lecture 19: 14 SQL 2016 Service pack SP1

Lecture 20: 15 SQl Data tools

Lecture 21: 16 full backups of source dbs

Lecture 22: 17 Data Migration Advisor

Lecture 23: 18 Migrate databases

Lecture 24: 19 Multiple job alerts operators script out

Lecture 25: 20A SSIS and SSRS imports

Lecture 26: 20B SSIS and SSRS imports

Lecture 27: 21 Deploying reports

Lecture 28: 22 Compatibilty issues

Lecture 29: 23 Compatibility issues extended

Lecture 30: 24 Decommission old database

Lecture 31: 25A In place upgrade

Lecture 32: 25B In place upgrade

Lecture 33: 26A Upgrade to SQL 2016

Lecture 34: 26B Upgrade to SQL 2016

Lecture 35: 27 Removing old files

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 2 votes
2 stars: 8 votes
3 stars: 61 votes
4 stars: 264 votes
5 stars: 411 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu