Script complete DB - 2005

  • 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

  • can you not just take a backup

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

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

  • 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

  • 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