How to backup Sql Server to sql file? – Stack Overflow

In “Back UP” I only get a bak file, but I would like to create .sql file

Sorgente: How to backup Sql Server to sql file? – Stack Overflow

I may need it pretty soon

up vote 25 down vote

Use SQL Server’s Generate Scripts commend right click on the database; Tasks -> Generate Scripts select your tables, click Next click the Advanced button find Types of data to script – choose Schema and Data. you can then choose to save to file, or put in new query window. results in CREATE and INSERT statements for all table data selected in bullet 2. shareimprove this answer answered Jul 21 ’11 at 21:00 p.campbell 58.4k51194278

add a comment

up vote 4 down vote

This is a possible duplicate of: SQL script to get table content as “SELECT * FROM tblname” To do a full database backup to File/Query you can use the ‘Generate Scripts…’ option on the Database. Open SQL Server Management studio, right click on the database and choose ‘Tasks->Generate Scripts…’ Then use the wizard to backup the database. You can script the whole database or parts of it. Two important options: In the ‘Advanced’ section, you will probably want to ensure ‘Type of backup = ‘Schema and Data’ and the ‘Script Statistics’ is on. This will produce a *.sql file that you can use as a backup that includes the schema and table data. shareimprove this answer answered Mar 6 ’11 at 23:34 Simon 5,08284192

1 it does not generate inserts 🙁 – IAdapter Mar 14 ’11 at 8:16 4 You need to ensure that ‘Type of Backup = Schema and Data’. It definately generates INSERT statements when you have selected this also. – Simon Mar 15 ’11 at 3:07 1 Specifically while on the “Set Scripting Options” step of the wizard you need to click “Advanced” to the right of the “Save to file”. Then under “Types of data to script” choose “Schema and data” – Jason Axelson Feb 20 ’13 at 2:42 add a comment

up vote 3 down vote	Ok, I read through most of these, but I had no “advanced button”. But, there is still a way to do it, it’s just a little hard to find, so here you go: shareimprove this answer answered Jun 13 ’13 at 15:38 Travis Heeter 1,9901743
	add a comment

up vote 2 down vote	You can generate a script from a database, see http://msdn.microsoft.com/en-us/library/ms178078.aspx shareimprove this answer answered Mar 6 ’11 at 18:47 cusimar9 3,29211429
	it does not generate inserts 🙁 – IAdapter Mar 14 ’11 at 8:16 add a comment

up vote 0 down vote

If you want to create a script of your database you right-click on the databases and Generate Scripts (it’s in different sub-menus depending on what version of SQL and Enterprise Manager / SQL Server Management studio you’re using). That will, however, only get you the database objects. It will not generate scripts for data. Backing up a database will give you all of the database objects as well as the data, depending on what recovery model your database is set to. shareimprove this answer answered Mar 6 ’11 at 18:48 squillman 6,92131945

add a comment

up vote 0 down vote	This fellow may have achieved what you are trying to do by creating the backup, and then restoring it and giving it a new name. This approach copies the data along with all of the database objects. shareimprove this answer edited Mar 6 ’11 at 18:54 answered Mar 6 ’11 at 18:48 DOK 25.5k64783
	add a comment

up vote 0 down vote

If you want a file with insert statements for your data have a look here: This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It’s very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes. http://vyaskn.tripod.com/code.htm#inserts