Migrating to Azure SQL Databases

SQL Server 2016    |    Intermediate
  • 13 videos | 1h 1m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 26 users Rating 4.7 of 26 users (26)
Migrating a database to Azure SQL Database primarily involves three steps: preparing, exporting, and importing. Explore the requirements and processes involved in migrating data to Azure SQL Databases.

WHAT YOU WILL LEARN

  • Recognize the various steps and considerations involved with migrating on-premise sql server databases to azure
    Recognize the tools available to test for sql database compatibility
    Describe how to migrate a non-sql server database
    Demonstrate how to migrate a sql server database using the microsoft azure database wizard
    Compare the bacpac export and transactional replication migration methods
    Demonstrate how to create a bacpac file to use in a database migration
    Explain the azure data factory
  • Describe the data transformation activities supported by azure data factory
    Discuss how to install the data management gateway
    Create linked services that connect to data sources in azure data factory
    Define and create tables to specify how to access datasets
    Demonstrate how to define, create, and start the pipeline
    Manage data using the azure data factory

IN THIS COURSE

  • 3m 23s
    After completing this video, you will be able to recognize the various steps and considerations involved with migrating on-premises SQL Server databases to Azure. FREE ACCESS
  • 3m 51s
    Upon completion of this video, you will be able to recognize the tools available for testing SQL Database compatibility. FREE ACCESS
  • Locked
    3.  Migrating Non-SQL Server Databases
    3m 10s
    Upon completion of this video, you will be able to describe how to migrate a database that is not SQL Server. FREE ACCESS
  • Locked
    4.  Microsoft Azure Database Wizard
    4m 46s
    In this video, you will learn how to migrate a SQL Server database using the Microsoft Azure Database Migration Wizard. FREE ACCESS
  • Locked
    5.  Comparing Migration Methods
    8m 28s
    In this video, you will learn how to compare the bacpac export and transactional replication migration methods. FREE ACCESS
  • Locked
    6.  Creating a BACPAC File
    6m 13s
    In this video, you will learn how to create a BACPAC file to use in a database migration. FREE ACCESS
  • Locked
    7.  Azure Data Factory
    6m 22s
    After completing this video, you will be able to explain the Azure data factory . FREE ACCESS
  • Locked
    8.  Data Transformation Activities
    3m 23s
    Upon completion of this video, you will be able to describe the data transformation activities supported by Azure Data Factory. FREE ACCESS
  • Locked
    9.  Installing the Data Management Gateway
    7m 5s
    In this video, you will discuss how to install the data management gateway. FREE ACCESS
  • Locked
    10.  Creating Linked Services
    2m 48s
    In this video, you will learn how to create linked services that connect to data sources in Azure. FREE ACCESS
  • Locked
    11.  Creating Tables to Access Datasets
    3m 23s
    In this video, you will learn how to define and create tables to specify how to access datasets. FREE ACCESS
  • Locked
    12.  Creating and Starting the Pipeline
    4m 6s
    In this video, you will learn how to define, create, and start a pipeline. FREE ACCESS
  • Locked
    13.  Exercise: Manage Data using Azure Data Factory
    4m 19s
    Find out how to manage data using Azure Data Factory. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 161 users Rating 4.6 of 161 users (161)
Rating 4.8 of 53 users Rating 4.8 of 53 users (53)
Rating 4.4 of 5 users Rating 4.4 of 5 users (5)