readme.md 1.7 KB
Data Portability
Notebooks in this chapter perform a data migration using a custom Azure function that can be deployed to an Azure subscription. It enables Azure Batch computing of a complex SQL Server migration to and from a single Resource Group. Azure Batch is a process that runs large-scale parallel and high-performance computing (HPC) batch jobs efficiently in Azure. This greatly reduces the processing required locally which should prevent long execution times, timeouts and retries. Importing and exporting data to and from Azure is supported for multiple SQL database instances. Data is imported and exported to and from standard SQL backup formats (*.bacpac) which "encapsulates the database schema as well as the data stored in the database" (Microsoft Docs).
Notebooks in this Chapter
Azure Data Portability Setup - Configure and install a custom Azure function to migrate data to and from Azure
Export Sql Server - from SQL Azure to a standard SQL backup format
Import Sql Server - from SQL backup format to Azure
Steps
- The Azure function must first be deployed using the setup notebook
- Open the notebook for the desired migration path (import or export)
- Configure and execute notebook
- Monitor progress with periodic notebook queries
- Verify data has been imported/exported by reviewing the storage account for the migrated Resource Group