How do i copy an exsiting database structure without data?


  • hi friends,

    I have database with 25 tables and max row count is about 15, 000. I need to create a copy of this database structure (without data) with a different name ( called as database versions)... How do I do this?


    I use Visual studio 2010 professional and SQL server 2008 developer edition!

    Sunday, September 08, 2013 6:54 AM


  • In SSMS do a right mouse click on the database => Tasks => Generate Scripts ...

    With the wizard you can generate create scripts for all existing objects like tables, views, procedures.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, September 08, 2013 7:27 AM
    • In .net, you can to use the SMO Library (this Library is used into SSMS)
    • Else, you can used the SSMS :

    The configuration Windows open.


    > Select objet type and objet name

    > Next

    The next window allows to define the save result AND to more configuration : clic to "Advanced" button.

    Sorry for my English, am french.

    • Proposed as answer by Grégory_Nail Sunday, September 08, 2013 8:16 AM
    • Marked as answer by sniff_bits Tuesday, September 10, 2013 1:56 AM
    Sunday, September 08, 2013 8:15 AM

All replies