How to manage R packages in Azure SQL Database with sqlmlutils
Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.
Start free todayIt’s just SQL: Restoring a database to Azure SQL DB from backup
Play It’s just SQL: Restoring a database to Azure SQL DB from backup
Description
In this video, Jeroen ter Heerdt shows how to restore a database to Azure SQL from a BACPAC file.
Read more about importing an Azure SQL Database from BACPAC.
Download
The Discussion
-
deltalmg911 How do you handle conflicts between Azure DB and on prem SQL Server when loading the bacpac? Ex your db scripts in SQL Server use the use, grant and other keywords not supported by Azure yet? Or is it because the bacpac is based off a db backup and not the scripts used to generate your db everything converts over fine? -
dutchdatadude @deltalmg911: if you try to restore from bacpac that uses features that are not supported, your backup will fail. I would recommend using Data Migration Assistant to get an idea of what is the right target before 'blindly' trying this. More info here: https://docs.microsoft.com/en-us/sql/dma/dma-assess-sql-data-estate-to-sqldb?view=sql-server-ver15
More episodes in this series
It's just SQL: Native Backup and Restore
Related episodes
It's just SQL: CLR in Azure SQL Database Managed Instance
How to connect to Azure SQL Database from Azure Data Studio
Deployment options for Azure SQL Database
It's just SQL: Collations in Azure SQL Database Managed Instance
Discovering, classifying, labeling & protecting SQL data – now available for all
Mark Russinovich on Azure SQL Database Edge, Hyperscale and beyond
Mark Russinovich on future of Azure and databases | Data Exposed
It's just SQL: Native Backup and Restore
How to manage R packages in Azure SQL Database with sqlmlutils
Benefit from SQL VM Resource Provider when self-installing SQL Server on Azure
