A few months ago I posted about the new SQL Server Database Publishing Hosting Toolkit built and published by the SQL Server team. You can read about what it offers and how to use it in these previous two blog posts of mine:
- Recipe: Deploying a SQL Database to a Remote Hosting Environment
- Tip/Trick: How to Upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
The SQL Server Hosting Toolkit is a free download that makes it super easy to create a .SQL script file capable of re-creating your database (including the schema, sprocs, and actual data content). When it is installed you can simply right-click on a database inside Visual Studio or Visual Web Developer and walkthrough a wizard to script it out:
You can then FTP this script up to your remote server environment and execute it (my second post above shows a technique you can use even if you don't have admin access on the machine). Alternatively, you can use the built-in web-service support provided by the database publishing wizard to directly export and copy the database over the Internet to your remote hosting provider.
SQL Server Database Publishing Toolkit V1.1 Update
Earlier this month the SQL team released a V1.1 update to the toolkit. You can learn more about it and download it here.
The V1.1 update includes the following improvements:
• It adds the ability to select individual objects/tables for publishing in the wizard (and not have to create/recreate everything in the database each time)
• It improves performance up to 30-40% when scripting and publishing
• It delivers usability improvements when publishing over the Internet to a hosting provider
• It fixes several bugs submitted on the CodePlex forums
I'd definitely recommend checking it out. If you are hosting your applications remotely today this free tool can be a super useful addition to your toolbox.