Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Sql server 2008 R2

Posted on 2011-02-18
Medium Priority
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?

Question by:Webboy2008
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
LVL 12

Expert Comment

ID: 34930972

Author Comment

ID: 34931163
How about sql server 2005.?

Author Comment

ID: 34931332
And I tried my sql server 2008. I don't see the option there.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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?

Author Comment

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

Expert Comment

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

Author Comment

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

Accepted Solution

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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

722 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