SQL Server: How to create a script of all data in a database

Question

How do I create a script of all the data in a particular database?

Thanks,

Sachin

You mean like mysqldump for MySQL? See: http://stackoverflow.com/questions/85186/mysqldump-equivalent-for-sql-server — Ocaso Protal, Nov 16 '12 at 13:46

score 1 · Accepted Answer · answered Nov 16 '12 at 14:20

This is a quick summary of what to do.

• In SQL Server Management Studio, connect to your database.

• Right-click on the database name in the object explorer

• In the context menu, mouse over "Tasks", and from the sub menu, click on "Generate Scripts"

• That will give you a popup window for "Generate and Publish Scripts"

• Read and follow the steps. Under "Set Scripting Options", click the "Advanced" button. Under general options, the last one should be "Types of data to script". Default is Schema Only. Change to "data and schema" to get both the table schema and data. Continue following the wizard.

Here's a link to the page in MSDN: http://msdn.microsoft.com/en-us/library/ms178078(v=sql.100).aspx

You can do more research on what to do.

SQL Server: How to create a script of all data in a database

1 Answers1