Migrating to Azure SQL Databases
SQL Server 2016
| Intermediate
- 13 videos | 1h 1m 16s
- Includes Assessment
- Earns a Badge
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 23sAfter 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 51sUpon completion of this video, you will be able to recognize the tools available for testing SQL Database compatibility. FREE ACCESS
-
3. Migrating Non-SQL Server Databases3m 10sUpon completion of this video, you will be able to describe how to migrate a database that is not SQL Server. FREE ACCESS
-
4. Microsoft Azure Database Wizard4m 46sIn this video, you will learn how to migrate a SQL Server database using the Microsoft Azure Database Migration Wizard. FREE ACCESS
-
5. Comparing Migration Methods8m 28sIn this video, you will learn how to compare the bacpac export and transactional replication migration methods. FREE ACCESS
-
6. Creating a BACPAC File6m 13sIn this video, you will learn how to create a BACPAC file to use in a database migration. FREE ACCESS
-
7. Azure Data Factory6m 22sAfter completing this video, you will be able to explain the Azure data factory . FREE ACCESS
-
8. Data Transformation Activities3m 23sUpon completion of this video, you will be able to describe the data transformation activities supported by Azure Data Factory. FREE ACCESS
-
9. Installing the Data Management Gateway7m 5sIn this video, you will discuss how to install the data management gateway. FREE ACCESS
-
10. Creating Linked Services2m 48sIn this video, you will learn how to create linked services that connect to data sources in Azure. FREE ACCESS
-
11. Creating Tables to Access Datasets3m 23sIn this video, you will learn how to define and create tables to specify how to access datasets. FREE ACCESS
-
12. Creating and Starting the Pipeline4m 6sIn this video, you will learn how to define, create, and start a pipeline. FREE ACCESS
-
13. Exercise: Manage Data using Azure Data Factory4m 19sFind 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.
