Post reply

Script complete DB - 2005

  • July 22, 2008 at 1:09 pm

    #189975

    Hi

    I have done this in sql server 2000 but am not sure how to accomplish this with 2005.

    I would like to script entire Sql server Db which includes

    (1) Tables

    (2) Stored Proc

    (3) Functions

    and stored as back up so that I can recreate the entire db. How can I accomplish this using Sql server 2005.

    Thanks

  • July 22, 2008 at 1:50 pm

    #846676

    can you not just take a backup

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 22, 2008 at 2:31 pm

    #846697

    I can but this stores the data too...I would like to just script the DB which will help by acting as a skeleton.

    Thanks

  • July 22, 2008 at 2:51 pm

    #846707

    You can right click on the database in SQL Server Management Studio and go to Tasks -> Generate Scripts. This will walk you through the process of selecting the tables, stored procedures, user defined functions, and views for the database you selected.

    You can take the generated script and run it on a new and blank database, and then take a backup of that database for future reference.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply