SQL Server Database Publishing Wizard Community Technology Preview 1 

Brief Description

The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts for later use.

Overview

SQL Server Database Publishing Wizard enables the deployment of SQL Server 2005 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.

More details here:SQL Server Hosting Toolkit

The goal of the SQL Server Hosting Toolkit is to enable a great experience around SQL Server in shared hosting environments.

The toolkit will eventually consist of a suite of tools and services that hosters can deploy for use by their customers. It will also serve as an incubation vehicle for tools that hosting customers can download and use directly, regardless of whether their hoster has deployed the toolkit. See the Project Roadmap for details on where we're going.

The first tool to be released as part of the toolkit is the Database Publishing Wizard, which makes it easy to upload databases to hosters.

If you're interested in meeting the folks at Microsoft behind this project, check out the Hosting Toolkit Team.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

My observations after testing it: http://sqlserver.ro/forums/thread/402.aspx

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro