Deploying a SQL database to a remote hosting environment (Part 1)

Transferred from scottgu's blog
Recipe: deploying a SQL database to a remote hosting environment...
This article describes how to use the SQL server hosting toolkit to deploy a database! Below are some original articles!
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
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)
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
Using DES 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)
Database Publishing Wizard also enables you to point at a database you
Are working with on your local system, and then use web-services
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
SQL Publishing Web-service be exposed in the hosting environment, and
The SQL server hosting toolkit has des a free implementation of this
SQL Publishing Web-service that we'll be working with hosters
Aggressively deploy.