up vote 20 down vote favorite
4

In my SQL Server 2008 R2

Script Option Screen of Script Wizard under section Table/View Options Look I find Script Data row and want to turn the option to True but I fail.

I don't find any script data option. Why script data option missing on my SQL Server 2008 R2? Is there any command to generate the insert data option.

Why this problem arise? how to solve it? Thanks in advance

share|improve this question

2 Answers

up vote 3 down vote accepted

Also if you have a lot of data in tables, you can use compression option to compress data, which decrease scripts heaviness and increase script executing speed.

share|improve this answer
up vote 58 down vote

It looks like they removed it from that location. You can still do it by:

  • Right clicking on the DB
  • Click on tasks
  • Click on generate scripts
  • Go through the wizard and select your tables
  • On the options page click the Advanced button
  • Change the "Types of data to script" option, from the default "Schema only" to "Schema and data".
share|improve this answer

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.