Kezdőlap Felfedezés Súgó
Regisztráció Bejelentkezés
Apq
/
tigertoolbox
tükrözi: https://github.com/microsoft/tigertoolbox.git
1
0
Másolás 0
Fájlok Problémák 0 Wiki
Fa: d626c076b8
Branch-ok Tag-ek
tigertoolbox
/
SQL-Hybrid-Cloud-Toolkit
/
content
/
data-portability
Alex Ma 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve
..
VisualBootstrapperNB.PNG 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve
export-sql-server.ipynb 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve
import-sql-server.ipynb 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve
readme.md 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve
setup-adp.ipynb 91f241c5cc added sql-hybrid-cloud-toolkit 5 éve

readme.md

Data Portability

Home

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

Steps

  1. The Azure function must first be deployed using the setup notebook
  2. Open the notebook for the desired migration path (import or export)
  3. Configure and execute notebook
  4. Monitor progress with periodic notebook queries
  5. Verify data has been imported/exported by reviewing the storage account for the migrated Resource Group