The SQL Server group at 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 we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.

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.

We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

Does the SQL Server Hosting Toolkit work alongside Visual Web Developer ?
Will it transfer ASPNETDB.MDF across to a shared SQL 2005 server - without having to write stacks of code ?
Will new ASP users be able to use it ?

Good to see that Microsoft is responding, otherwise you are going to frustrate a lot of VWD newbies ....

Just seen that DiscountASP.NET have a SQL 2005 Attach MDF Tool ... it seems they have recognised that thousands of new VWD user are having real problems moving databases from local to server.

this is a great little tool, thanks for making it available! I've been looking for a utility to pull an image of a hosted database for some time but had no luck finding it. This tool actually works to pull data of a remote SQL 2000 Server.

 Whatever you add in the future, please keep the command line available. That will enable this tool for backup purposes.

 For a moment I was confused when I could not open the result file in vim. Apparently the format is unicode or whatever 2 byte character encoding is called. I think it would be useful if there was an option to generate plain-simple 1 byte character text files. If only because the size gets cut in half :)
 

Thanks for your feedback Nocturnal.  We'll definitely be keeping the command line.  Interesting idea on the single byte text output.  The problem would be potential data loss, but we might be able to detect that and throw an error...

By the way, check out the new CTP we just released at http://www.codeplex.com/sqlhost

Thanks,
Dan

Yeah, it didn't.

 My source table is 2000, targe is 2000 as well, publish schema only. Get an error while in Gathering list of objects to script. says need 2005 or later. :(  had to use the Red Gate sql compare instead.
 

Very Very Good efforts by the team.

This tools are very much appreciated and welcomed.

I think backup, restore facilities should be included in future versions they are a must. I think dotnet panel is utilising them very smoothly.This could be a disadvantage for users if their host is providing some panels and this is a common scenerio.

-------------------------------------------------------------------------------------------------------------------------------------
A little information required here....

What if i upload a new data from my local SQL2005 to remote SQL2005. I just want my local sql2005 to be along with remote sql2005, i do not want to over write the remote sql2005. Is it possible...?

e.g:- my remote has 10 datas. I want to add 2 datas more from my local sql2005 to remote sql2005 to make it 12 datas on remote.
If i over write it will become 2 on remote, i will looose 10 datas.

I hope i have cleared. Thi facility if not added to day, should be considered for future
---------------------------------------------------------------------------------------------------------------------------------------------------

I was surprised no one has mentioned the links for great tutorials for this tool by Mr. Scott Guthrie.

Any how its here...

Tutorial 1

and

Tutorial 2

Cheers!

We are currently using the Team Edition for Database Pros plug in for VS Team Suite, along with Web Deployment Projects and Team Build for Team Foundation Server.

Do you think this new utility has a place in that kind of environment?  Currently, the database project generates a SQL deployment script when we do a team build, and we can also use the database project's Schema Compare and Data Compare to sync our live databases. 

Same problem tried with Sql 2000 and failed :(

I tried with SQL 2000 but got an errors.

DBMaster

MyBlog

thank you