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.
Http://www.cnblogs.com/MichaelPeng/archive/2009/04/25/1443282.html
Http://www.codeplex.com/sqlhost/Wiki/View.aspx? Title = database % 20 publishing % 20 wizard