New tools for Database Hosting (SQL Server Hosting Toolkit)...
Release Candidate of the SQL Server Hosting Toolkit went live on the web yesterday! This includes both the Database Publishing Wizard and the Database Publishing Services.
Database Publishing Wizard
The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
- It generates a single SQL script file which can be used to recreate a database when the only connectivity to a server is through a web-based control panel with a script execution window.
- It connects to a web service provided by your hoster and directly creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a command-line interface. In addition, it can integrate directly into Visual Studio 2005 or Visual Web Developer 2005.
Database Publishing Services
As a hoster, you can use Database Publishing Services to enable your customers to easily deploy their SQL Server databases into your environment with tools such as the Database Publishing Wizard
