SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)

by

This functionality is already built in to Sql Server Management Studio 2008.

Just download the trial and only install the client tools (which shouldn’t expire). Use Management Studio 2008 to connect to your 2005 database (its backwards compatible).

  1. Right click your database
  2. Choose Tasks > Generate Scripts
  3. Press Next, select your database again
  4. On the ‘Choose Script Options’ screen, there is an option called Script Data which will generate SQL insert statements for all your data.

(Note: for SQL Server Management Studio 2008 R2, the option is called “Types of data to script” and is the last one in the General section. The choices are “data only”, “schema and data”, and “schema only”)

alt text
alt text

More Related Contents:

  1. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  2. Insert results of a stored procedure into a temporary table
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. Select top 10 records for each category
  5. The multi-part identifier could not be bound
  6. How important is the order of columns in indexes?
  7. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  8. sql query to return differences between two tables
  9. SQL Server – transactions roll back on error?
  10. Difference between a User and a Login in SQL Server
  11. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  12. Fastest way to update 120 Million records
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. How to find current transaction level?
  15. Insert Picture into SQL Server 2005 Image Field using only SQL
  16. How to insert multiple records and get the identity value?
  17. Execute Stored Procedure from a Function
  18. How do I group on continuous ranges
  19. How can a LEFT OUTER JOIN return more records than exist in the left table?
  20. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  21. Column name or number of supplied values does not match table definition
  22. Restrict an SQL Server connection to a specific IP address
  23. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  24. SQL server identity column values start at 0 instead of 1
  25. How do you copy a record in a SQL table but swap out the unique id of the new row?
  26. How to compare dates in SQL Server
  27. How do I expand comma separated values into separate rows using SQL Server 2005?
  28. SQL Sort Order with Null values last
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment