mysqldump equivalent for SQL Server

by

To do this really easily with SQL Server 2008 Management Studio:

1.) Right click on the database (not the table) and select Tasks -> Generate Scripts

location of tool

2.) Click Next on the first page

3.) If you want to copy the whole database, just click next. If you want to copy specific tables, click on “Select Specific Database Objects”, select the tables you want, and then click next.

4.) “Save to File” should be selected. IMPORTANT: Click the Advanced button next to “Save to File”, find “Types of data to script”, and change “Schema only” to “Schema and data” (if you want to create the table) or “Data only” (if you’re copying data to an existing table).

adding data to the script

5.) Click through the rest and you’re done! It will save as a .sql file.

More Related Contents:

  1. SQL Server String or binary data would be truncated
  2. incorrect syntax near keyword where [closed]
  3. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  4. How do I create a unique constraint that also allows nulls?
  5. How do I get list of all tables in a database using TSQL?
  6. How to convert SQL Server’s timestamp column to datetime format
  7. Multiple rows to one comma-separated value in Sql Server [duplicate]
  8. Escape a string in SQL Server so that it is safe to use in LIKE expression
  9. Storing files in SQL Server
  10. SQL Server: Difference between PARTITION BY and GROUP BY
  11. How do you truncate all tables in a database using TSQL?
  12. Dapper.NET and stored proc with multiple result sets
  13. Import ‘xml’ into Sql Server
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. T-SQL Dynamic SQL and Temp Tables
  16. Efficient ISNUMERIC() replacements on SQL Server?
  17. Login to Microsoft SQL Server Error: 18456
  18. SQL Server datetime LIKE select?
  19. Adding a query hint when calling Table-Valued Function
  20. Find non-ASCII characters in varchar columns using SQL Server
  21. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  22. How can I determine in SQL Server if a dateTime range overlaps another
  23. Intermittent ODBC connection failures
  24. SQL Server Query – groupwise multiplication
  25. SQL Server recursive query
  26. Getting week number off a date in MS SQL Server 2005?
  27. Set database collation in Entity Framework Code-First Initializer
  28. “No backupset selected to be restored” SQL Server 2012
  29. comma delimited list as a single string, T-SQL [duplicate]
  30. Count number of records returned by group by

Leave a Comment