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...
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-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
