Generate Script with full data from sql server (sql server management studio)

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hello,

I have create one application with sql server database, for maintain table, stroed procedure,I have using sql server management studio.
Now i want to back up full data means i have inserted around more than 500 records. so, i want to back with 500 records and table scripts all as in sql script. which file's extension is .sql.

Thanks & Regards,

Posted 13-Oct-14 3:14am

Pratham4950

Add a Solution

Comments

[no name] 13-Oct-14 9:17am

Okay so generate the script with SSMS. What is the problem?

Pratham4950 13-Oct-14 9:25am

my problem is i want full data (e.g i have more than 500 records in one table) with generate script, bu default it's only generate database structure.

[no name] 13-Oct-14 12:23pm

Then you need to select the option to generate the script with data also.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sankarsan parida · Answer 1 · 2014-10-13T03:26:00

Solution 1

When you are generating script

1. In Set scripting Option window Click on  Advanced button
2. One Option window will appear
3. There is a option in General "Types of data script":
4. Choose "Schema and data"

You will get table script with table records insert script

Posted 13-Oct-14 3:26am

sankarsan parida