Solved

Sql server 2008 R2

Posted on 2011-02-18
8
288 Views
Last Modified: 2012-08-13
I have some tables that have data there. My plan is to have one .sql to do the following:

1. The script will have create table code and all of the data in the table will be in the script as well.

for example. I have table customer and have column first name, last name with data John Smith.
I want to get script from sql server 2008. Included the table structure and the data into one script. Does it seem possible?

Thanks,
0
Comment
Question by:Webboy2008
  • 4
  • 3
8 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 34930972
0
 

Author Comment

by:Webboy2008
ID: 34931163
How about sql server 2005.?
0
 

Author Comment

by:Webboy2008
ID: 34931332
And I tried my sql server 2008. I don't see the option there.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34931362
>>How about sql server 2005.? <<
"Script Data option is new with Microsoft SQL Server 2008"

>>And I tried my sql server 2008. I don't see the option there.<<
Are you using the Express Edition?
0
 

Author Comment

by:Webboy2008
ID: 34931403
It is Sql 2008 Server. Not express
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34934068
Ok.  So what option is not there?
0
 

Author Comment

by:Webboy2008
ID: 34964507
Script Data = True is not there.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 34966972
Right.  By default it is not there.  You have to change it from Script Data = False to Script Data = True.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 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