Script database with data

Question

While I am generating script of a database, only the tables and stored procedures are scripted. But I also want the data also. I am using SQL Server 2008. Is there any provision to script with data in a single file?

You mean you are trying to extract data from an existing database or you want to be able to put data in a database on deployment? — lc.
– lc., Commented Feb 8, 2013 at 10:26

Sobhan · Accepted Answer · 2013-02-08 10:28:57Z

1

set the script data option to true in the "Choose Script option wizard"

You can also refer to

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

answered Feb 8, 2013 at 10:28

Sobhan

8262 gold badges12 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SQLGuru · Accepted Answer · 2013-02-08 10:28:01Z

0

APEXSQL have a tool that will allow you to script your entire DB with data...

answered Feb 8, 2013 at 10:28

SQLGuru

1,0975 silver badges14 bronze badges

Comments

neelsg · Accepted Answer · 2013-02-08 10:30:24Z

0

You can always write your own if it is not too much effort. You can even automate some of it using excel etc. To do this, try:

SELECT 'INSERT INTO sometable (field1, field2, field3)
 VALUES (''' + field1 + ''', ''' + field2 + ''', ''' + field3 + ''');'
 AS insrow FROM sometable

answered Feb 8, 2013 at 10:30

neelsg

4,8425 gold badges37 silver badges58 bronze badges

Collectives™ on Stack Overflow

Script database with data

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related