It’s just SQL: Restoring a database to Azure SQL DB from backup

The Discussion

• 

  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?

• 

  @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