Sql server 2008 R2

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,
Webboy2008Asked:
Who is Participating?
 
Anthony PerkinsCommented:
Right.  By default it is not there.  You have to change it from Script Data = False to Script Data = True.
0
 
Webboy2008Author Commented:
How about sql server 2005.?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Webboy2008Author Commented:
And I tried my sql server 2008. I don't see the option there.
0
 
Anthony PerkinsCommented:
>>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
 
Webboy2008Author Commented:
It is Sql 2008 Server. Not express
0
 
Anthony PerkinsCommented:
Ok.  So what option is not there?
0
 
Webboy2008Author Commented:
Script Data = True is not there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.