It would be interesting to see someone test out the SQL Server Hosting Toolkit for publishing their scientific data – imagine capturing it locally and then publishing it to a Science SQL hosting service, so all the other researchers in your space could test out their algorithms on your datasets.
Details on the Database Publishing Wizard as well as the download can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.
Future plans for the Hosting Toolkit can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Project%20Roadmap
From Laurent Bonnet [MS France] blog:
Very interesting addtion for web hosters who want to simplify their customers procedures on Shared or Dedicated hosted solutions using ASP.Net 2.0 and SQL Server 2005: Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1.
The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles.
In the coming months, Microsoft will be adding a GUI, integrate it into Visual Studio, and enable seamless deployment from the tool to an upload service hosters will be able to deploy.