Solved

Sql server 2008 R2

Posted on 2011-02-18
8
290 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

636 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