Finally, an easy way to script databases beyond just the schema scripting the database tools provide. The wizard is part of the SQL Server Hosting Toolkit. It would be too much to hope that some hosting companies will roll it out and drop the cost of having a hosted SQL server. Why is SQL hosting so damned expensive?

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.

Unfortunately it's limited to creation scripts, there's no compare and update functionality so once you've published your database you can forget about using the tool again. I have used red-gate's tools for this before and frankly if you're serious about scripting your databases these are the tools to buy. It's just a shame they're so damned expensive and the schema and data products are, for some reason, seperate thus incurring more cost.