[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Server generating datamodel scripts

Posted on 2011-05-10
Medium Priority
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 databse...how 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

Ephraim Wangoya earned 2000 total points
ID: 35734757

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
ID: 35736111
Generate script by clicking database property.

Author Closing Comment

ID: 35757646

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

872 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