how clone database

Question

hello all how to copy a mssql database to another database. I want to copy only the structure not the content. tq & regard denny

Raaj Kumar · Answer

Hi 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