Recipe: Deploying a SQL Database to a Remote Hosting Environment ...
讲述如何运用SQL Server Hosting Toolkit部署数据库，期待他的第二篇！下面是一些原文！
The good news is that this week the SQL Server team published the release candidate of a new SQL Server Hosting Toolkit
that will make it much, much easier to deploy your SQL solutions
remotely to a hosted environment. The toolkit allows you to work with
SQL Express, SQL Server 2000, and SQL Server 2005 databases locally,
and then easily transfer your schema and data and install them into a shared hosting remote SQL Server account.
SQL Server Hosting Toolkit
The SQL Server Hosting toolkit is available for free, and ships with a Database Publishing Wizard that supports two database hosting deployment scenarios:
1) The
Database Publishing Wizard enables you to point at a database you are
working with on your local system, and then automatically create a .SQL
script file that contains the setup logic needed to re-create an exact
replica of the database on any remote system. This .SQL script
includes everything needed to create the database schema (tables,
views, sprocs, triggers, full-text catalogs, roles, rules, etc - full details here),
as well as populate the new database with the same table row contents
as your local database (this is analogous to the MySQL dump utility).
The benefit of having this setup logic encapsulated in a single .SQL
file is that most hosters already support the ability for you to upload
.SQL files to their hosted environments and run these scripts via their
hosting admin control panels. Assuming you have a web hoster that
supports this today, you can immediately start using the Database
Publishing Wizard to easily deploy your sites without requiring
anything to be installed or configured by the hoster.
2) The
Database Publishing Wizard also enables you to point at a database you
are working with on your local system, and then use web-services to
transfer and recreate the database in your remote hoster environment
(without you having to create the .SQL file or use the hoster admin
control panel to run it). This publishing option does require that a
SQL Publishing web-service be exposed in the hosting environment, and
the SQL Server Hosting Toolkit includes a free implementation of this
SQL Publishing web-service that we'll be working with hosters to
aggressively deploy.