Copy a Azure SQL DB with just the objects and no data

Question

Hi,

How can we copy the objects of an Azure SQL Database from one tenant to another tenant without copying the data, just the structure?

I was able to copy the database following this copy-to-a-different-subscription documentation from Microsoft using SQL scripts. But this doesn't talk about how we can copy the database without the data.

Does anybody have any suggestion?

Answer 1

You can create a dacpac (containing only the database schema) of the existing database using SqlPackage and then just import it into an Azure SQL logical server that exist on the other tenant.

sqlpackage.exe /Action:Export /ssn:tcp:{SERVERNAME}.database.windows.net,1433 /sdn:{DBNAME} /su:*** /sp:*** /tf:C:\temp\{DBNAME}.bacpac

Here you will find more information about the export action of the SqlPackage tool.

Answer 2

Hi @Swathi Sudheer

How about Generate Scripts wizard for scripts of all database objects.

SSMS >Right click the database > Tasks > Generate Scripts. During the process, please choose script Schema only option as below screenshot.

Here is a blog for reference Methods to script SQL Server database objects

Another reference document- https://www.mssqltips.com/sqlservertip/4664/copy-a-sql-server-database-with-just-the-objects-and-no-data/

Thank you!