Forum Discussion
Azure SQL Database, Schema Backup and Restore
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
Hi
May be you can useSql 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-programmatically-with-sqlcmd/amp/- 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,
DonaldHi 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
