Azure SQL Database, Schema Backup and Restore

[DonaldCollins]

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

[#2]

Hi
May be you can use

Sql Management Studio to do export

 : https://codebots.com/docs/export-schema-using-sql-server-management-studio-ssms

and Sql Cmd to do the import :
https://azurecloudai.blog/2016/02/23/import-database-schema-in-azure-sql-db-from-sql-files-programma...

[#3]

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

[#4]

@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