Get SQL dump with data from SQL server 2008 studio

From Notes_Wiki
Revision as of 19:19, 19 April 2021 by Saurabh (talk | contribs) (Created page with "<yambe:breadcrumb self="Get SQL dump with data from SQL server 2008 studio">Microsoft SQL server|Microsoft SQL server</yambe:breadcrumb> =Get SQL dump with data from SQL serve...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

<yambe:breadcrumb self="Get SQL dump with data from SQL server 2008 studio">Microsoft SQL server|Microsoft SQL server</yambe:breadcrumb>

Get SQL dump with data from SQL server 2008 studio

To get SQL dump with data (Table rows including values) from SQL server 2008 studio use following steps:

  1. Right click on database and from Tasks menu choose "Generate scripts"
  2. Choose to generate scripts for required tables / views etc. or for entire database and click next
  3. On the next screen with option to specify SQL dump destination file click "Advanced"
  4. In the popup change value of "Types of data to script" from "Schema only" to "Schema and Data"
  5. Close the popup and specify other details as per need
  6. Export the SQL dump

Refer:


<yambe:breadcrumb self="Get SQL dump with data from SQL server 2008 studio">Microsoft SQL server|Microsoft SQL server</yambe:breadcrumb>

Retrieved from "http://www.sbarjatiya.com/notes_wiki/index.php?title=Get_SQL_dump_with_data_from_SQL_server_2008_studio&oldid=5022"