Forum Discussion

Copper Contributor

May 26, 2021

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

ibnmbodji

Iron Contributor

May 26, 2021

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/