SQL Server Migration and Upgrade Process
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
- Preview11:01
- 11:592 Why do you want to migrate
- 10:003A Download and install apps
- 11:563B Download and install apps
- 10:004A Configure Domain Controller
- 16:034B Configure Domain Controller
- 13:005A Installing VM for SQL 2012 old system
- 12:135B Installing VM for SQL 2012 old system
- 12:246 Installing SQL 2012
- 09:237 Adding Objects
- 09:548 Reports and packages
- 13:369 Migration options
- 13:0010A Gathering task data
- 13:4310B Gathering task data
- 10:0011A Creating VM for SQL 2016
- 14:1811B Creating VM for SQL 2016
- 12:5212 Installing SQL 2016
- 10:4413 Installing SSMS
- 12:2414 SQL 2016 Service pack SP1
- 05:2415 SQl Data tools
- 10:0616 full backups of source dbs
- 19:5417 Data Migration Advisor
- 18:5818 Migrate databases
- 10:2119 Multiple job alerts operators script out
- 14:5920A SSIS and SSRS imports
- 15:4120B SSIS and SSRS imports
- 09:0321 Deploying reports
- 11:3722 Compatibilty issues
- 04:3323 Compatibility issues extended
- 06:0324 Decommission old database
- 15:0025A In place upgrade
- 15:4925B In place upgrade
- 15:0026A Upgrade to SQL 2016
- 17:4626B Upgrade to SQL 2016
- 12:4027 Removing old files
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
Instructor
Worked as a Production SQL Database Administrator and developer for over 15 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.