hello all
how to copy a mssql database to another database.
I want to copy only the structure ,not the content.
tq & regard
denny
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Raaj KumarPosted Feb 28, 2010, 11:23 PM
You can do this by 2 ways. One is backup-and-restore and other is generating script. For your requirement, script based method should be used. Once you generate the script which is pure SQL statements, you can send the script to the machine where you want to clone. So I will provide you a link where you can find a tutorial for the same.
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
Regards,
raaj