Publishing your SQL Server 2005 database?
Ever wanted to MySQL feature that let’s you script out a database (including the data) when working with SQL Server?
Fear no more the Database Publishing Wizard is here to help.
The 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 SQL script file which can be used to recreate the database in shared hosting environments where the only connectivity to a server is through a web-based control panel with a scripting window.
The Database Publishing Wizard is currently a command line tool, though future releases will add a graphical user interface.
Get the download from here. Keep in mind that it’s still a CTP and is being developed actively.