Azure SQL Database, Schema Backup and Restore

Occasional Contributor

Hi Community,
Is there a way to backup and restore just a single Azure schema in an Azure SQL Database?
And/or is there a way to take an export copy a single Azure schema and then import it back in to same Azure SQL Database?
Thank you for your time.
Best Regards,
Donald

3 Replies
Hi ibrahimambodji, Thank you for your quick reply and suggested workaround. I think mgmt is looking for a native tool in Azure or Sql Management Studio to create a backup file with restore capabilities on the schema level. Is there anything like that available?
Thank you for your time.
Best Regards,
Donald

@DonaldCollins 

Hi no problem  

 

As far i know the only native tool that is available for import / export operations is the use of BACPAC file which encapsulates  not only  database's schema but also the  data.

https://docs.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell