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 Azurerecognize the tools available to test for SQL Database compatibilitydescribe how to migrate a non-SQL Server databasedemonstrate how to migrate a SQL Server database using the Microsoft Azure database wizardcompare the bacpac export and transactional replication migration methodsdemonstrate how to create a BACPAC file to use in a database migrationexplain the Azure data factory
-
describe the data transformation activities supported by Azure data factorydiscuss how to install the data management gatewaycreate linked services that connect to data sources in Azure data factorydefine and create tables to specify how to access datasetsdemonstrate how to define, create, and start the pipelinemanage data using the Azure Data Factory
IN THIS COURSE
-
1.Migrating a Database Overview3m 23sUP NEXT
-
2.Compatibility Testing3m 51s
-
3.Migrating Non-SQL Server Databases3m 10s
-
4.Microsoft Azure Database Wizard4m 46s
-
5.Comparing Migration Methods8m 28s
-
6.Creating a BACPAC File6m 13s
-
7.Azure Data Factory6m 22s
-
8.Data Transformation Activities3m 23s
-
9.Installing the Data Management Gateway7m 5s
-
10.Creating Linked Services2m 48s
-
11.Creating Tables to Access Datasets3m 23s
-
12.Creating and Starting the Pipeline4m 6s
-
13.Exercise: Manage Data using Azure Data Factory4m 19s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.