Overview

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.

System requirements

Supported Operating Systems: Windows Server 2003, Windows Vista, Windows XP

• Required software: SQL Server Database Publishing Wizard requires the following components to be installed:



• Microsoft .NET Framework Version 2.0 Redistributable Package (x86)
• Microsoft SQL Server 2005 Management Object Collection, available within the Feature Pack for SQL Server 2005
• Optional software: SQL Server Database Publishing Wizard can optionally integrate with either Visual Studio 2005 (Standard and higher) and/or Visual Web Developer 2005

Instructions

1. Install any required components from above that have not already been installed


2. Click the Download button on this page to start the download


3. Install the SQL Server Database Publishing Wizard by selecting the Run option

Additional information

For more information, visit the SQL Server Hosting Toolkit project page