XML Feeds
There seems to be a little bit of confusion on how to script out the database. The correct answer is of course: just run all the scripts you have in source control :-)
So for those who do not use/have source control I will show you how to do it
Logically you would think that this would be the way: Right click on the database --> Script Database As --> CREATE To and then pick your choice. See also image below
What that will do is just create the database and not much else, here is what the script might look like
- USE [master]
- GO
- /****** Object: Database [AdventureWorks] Script Date: 06/30/2009 15:04:19 ******/
- CREATE DATABASE [AdventureWorks] ON PRIMARY
- ( NAME = N'AdventureWorks_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf' , SIZE = 174080KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
- LOG ON
- ( NAME = N'AdventureWorks_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 16384KB )
- GO
- ALTER DATABASE [AdventureWorks] SET COMPATIBILITY_LEVEL = 100
- GO
- IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
- BEGIN
- EXEC [AdventureWorks].[dbo].[SP_FULLTEXT_DATABASE] @ACTION = 'enable'
- END
- GO
What you have to do is actually this: Right click on your database-->Tasks-->Generate Scripts
Select the database you want to script and make sure you check the option at the bottom that says Script all objects in the selected database. See image below
That is all, click next a couple of times and review your options and you are set
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.