Something as simple as getting the sql dump of a database in Microsoft SQL Server (2000, 2005 et al) to a SQL file could be quite a bit complicated (atleast more so as compared to the way we do it in MYSQL). SQL Server Management Studio does a good job of creating scripts that can help you recreate Database Schema. But when it comes to recreating the real Database data through SQL scripting sadly it simply just doesn’t have any simple method to accomplish it (as far as I know it).

The best way to accomplish this MS SQL is by using Microsoft SQL Server Database Publishing Wizard 1.1. It seems to be a pretty good tool because of its simplicity, stability, accuracy and ease of use. Once you download & install it, you can choose either the tool’s GUI or the command line interface to generate a single SQL script file which can be used to recreate a database (both schema and data). What is mire, there is even a bonus feature of being integrable with Visual Studio!

Download it from the Microsoft Download Page for Microsoft SQL Server Database Publishing Wizard 1.1


2 Responses to “Howto: Backup Microsoft SQL Server Database, as in Dump it to a SQL Script (like MYSQL’s sqldump)”

  1. vid Says:

    Thanks for the mention Josefina

  2. Josefina Seats Says:

    This post was mentioned on Facebook by Richard Hawkesford.

Leave a Reply


Recent Comments