SQL Server Database Publishing Toolkit for Web Hosting

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.

Posted in Microsoft Technology Tagged with: