Solved

Sql server 2008 R2

Posted on 2011-02-18
8
281 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
 
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

943 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

10 Experts available now in Live!

Get 1:1 Help Now