Jun
1
Written by:
Javier Callico
6/1/2007
If you like the simplicity and convenience of plain text backups for your databases then you will find the “SQL Server Database Publishing Wizard” a must have tool for your day to day life as developer.
I just found out about this tool a week ago but I’m already using it to take snapshots of my databases for backup and deployment purposes. I love the fact that I can script the schema and/or the data.
According to Microsoft’s overview for this tool:
SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window. If supported by the hosting service provider, the Database Publishing Wizard can also directly upload databases to servers located at the shared hosting provider.
Optionally, SQL Server Database Publishing Wizard can integrate directly into Visual Studio 2005 and/or Visual Web Developer 2005 allowing easy publishing of databases from within the development environment.
Click here to visit the download page at microsoft.com
1 comment(s) so far...
Re: Scripting your MSSQL database using the SQL Server Database Publishing Wizard
Hi,
Thanks for the tip about using the publishing wizard to copy a group of tables in a schema to a file. Worked great!
Maria
By Maria Thomadakis on
7/15/2010
|