SQL Server generating datamodel scripts

Posted on 2011-05-10
Last Modified: 2012-05-11
Hi ,

I have my database with 120  tabels. I want to have  back scripts for this databse i.e datamodel..

I mean I want to have script so that  I can re-create tables in new can i do this in swl server 2008 , Do have any 3rd party tools for this...

Please  help me... to solve this issue
Question by:N_Sri
    LVL 32

    Accepted Solution


    Right click on the database you want to script
    Select Tasks->Generate Scripts..

    Then you can follow the wizard and select the objects that you want to script
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Generate script by clicking database property.

    Author Closing Comment


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now