SQL Server: Create a duplicate of a database without the data

Question

I have a database called AQOA_Core with huge amount of data. I have a newly created database called AQOA_Core1 which is basically empty. I want to write a query to duplicate AQOA_Core to AQOA_Core1 without the data. I guess to be precise I want to create a skeleton of the primary database into the secondary database. PS: I use Toad for my database operations.

SQL Delta is the best tool to compare Different Database structure and syncronize two instances — Galma88
– Galma88, Commented Jun 30, 2015 at 13:51
If you were using SQL Server Management Studio, you could right click on the database and choose "Script Database as --> Create", which would generate the script you need. — Gordon Linoff
– Gordon Linoff, Commented Jun 30, 2015 at 13:54

Eralper · Accepted Answer · 2015-06-30 13:54:41Z

1

You can use SQL Server Script Wizard for scripting database objects. You can exclude data, and select the database object types you want to include in your script

Please check the SQL Server guide I referenced above, I hope it helps you

answered Jun 30, 2015 at 13:54

Eralper

6,6402 gold badges23 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server: Create a duplicate of a database without the data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related