Azure SQL Database, Schema Backup and Restore

%3CLINGO-SUB%20id%3D%22lingo-sub-2389150%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%2C%20Schema%20Backup%20and%20Restore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2389150%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%3CBR%20%2F%3EIs%20there%20a%20way%20to%20backup%20and%20restore%20just%20a%20single%20Azure%20schema%20in%20an%20Azure%20SQL%20Database%3F%3CBR%20%2F%3EAnd%2For%20is%20there%20a%20way%20to%20take%20an%20export%20copy%20a%20single%20Azure%20schema%20and%20then%20import%20it%20back%20in%20to%20same%20Azure%20SQL%20Database%3F%3CBR%20%2F%3EThank%20you%20for%20your%20time.%3CBR%20%2F%3EBest%20Regards%2C%3CBR%20%2F%3EDonald%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2389322%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%2C%20Schema%20Backup%20and%20Restore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2389322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CBR%20%2F%3EMay%20be%20you%20can%20use%3C%2FP%3E%3CP%3ESql%20Management%20Studio%20to%20do%20export%3C%2FP%3E%3CP%3E%26nbsp%3B%3A%20%3CA%20href%3D%22https%3A%2F%2Fcodebots.com%2Fdocs%2Fexport-schema-using-sql-server-management-studio-ssms%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcodebots.com%2Fdocs%2Fexport-schema-using-sql-server-management-studio-ssms%3C%2FA%3E%3C%2FP%3E%3CP%3Eand%20Sql%20Cmd%20to%20do%20the%20import%20%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fazurecloudai.blog%2F2016%2F02%2F23%2Fimport-database-schema-in-azure-sql-db-from-sql-files-programmatically-with-sqlcmd%2Famp%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fazurecloudai.blog%2F2016%2F02%2F23%2Fimport-database-schema-in-azure-sql-db-from-sql-files-programmatically-with-sqlcmd%2Famp%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2390978%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%2C%20Schema%20Backup%20and%20Restore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390978%22%20slang%3D%22en-US%22%3EHi%20ibrahimambodji%2C%20Thank%20you%20for%20your%20quick%20reply%20and%20suggested%20workaround.%20I%20think%20mgmt%20is%20looking%20for%20a%20native%20tool%20in%20Azure%20or%20Sql%20Management%20Studio%20to%20create%20a%20backup%20file%20with%20restore%20capabilities%20on%20the%20schema%20level.%20Is%20there%20anything%20like%20that%20available%3F%3CBR%20%2F%3EThank%20you%20for%20your%20time.%3CBR%20%2F%3EBest%20Regards%2C%3CBR%20%2F%3EDonald%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2391038%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%2C%20Schema%20Backup%20and%20Restore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2391038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F982497%22%20target%3D%22_blank%22%3E%40DonaldCollins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20no%20problem%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20i%20know%20the%20only%20native%20tool%20that%20is%20available%20for%20import%20%2F%20export%20operations%20is%20the%20use%20of%20BACPAC%20file%20which%20encapsulates%26nbsp%3B%20not%20only%26nbsp%3B%20database's%20schema%20but%20also%20the%26nbsp%3B%20data.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fdatabase-import%3Ftabs%3Dazure-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fdatabase-import%3Ftabs%3Dazure-powershell%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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