Click here to Skip to main content
14,922,492 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:

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,
[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

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

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900