How to get script of SQL Server data?

sql sql-server export
Jared picture Jared · Feb 23, 2010 · Viewed 227.1k times · Source

I'm looking for a way to do something analogous to the MySQL dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow).

I need this data to be able to turn around and go back into SQL Server so it needs to maintain GUIDs/uniqueidentifiers and other column types.

Does anyone know of a good tool for this?

Answer

Daniel Vassallo picture Daniel Vassallo · Feb 23, 2010

From the SQL Server Management Studio you can right click on your database and select:

Tasks -> Generate Scripts

Then simply proceed through the wizard. Make sure to set 'Script Data' to TRUE when prompted to choose the script options.

SQL Server 2008 R2

alt text

Further reading:

Related questions

How to export all data from table to an insertable sql format?

I have a Table (call it A_table) in a database (call it A_db) in Microsoft SQL Server Management Studio, and there are 10 rows. I have another database (call it B_db), and it has a Table (call it …

Read More
Export table data from one SQL Server to another

I have two SQL Servers (both 2005 version). I want to migrate several tables from one to another. I have tried: On source server I have right clicked on the database, selected Tasks/Generate scripts. The problem is that under Table/…

Read More
Export database schema into SQL file

Is it possible in MS SQL Server 2008 to export database structure into a T-SQL file? I want to export not only tables schema but also primary keys, foreign keys, constraints, indexes, stored procedures, user defined types/functions. Also I don't …

Read More