How do I create a script of all the data in a particular database?
Thanks,
Sachin
asked Nov 16, 2012 at 13:39
-
Do you have SQL Server Management Studio? (not express)CM Kanode– CM Kanode2012-11-16 13:44:38 +00:00Commented Nov 16, 2012 at 13:44
-
You mean like mysqldump for MySQL? See: stackoverflow.com/questions/85186/…Ocaso Protal– Ocaso Protal2012-11-16 13:46:21 +00:00Commented Nov 16, 2012 at 13:46
Add a comment
|
1 Answer
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.
