Deploy the SQL database to the remote database server

TodayScott Guthrie's blog found SQL server hosting toolkit. I don't know if you are using it anymore. In the garden, it seems that I haven't seen anyArticleSo I will share it with you. SQL server hosting Toolkit This toolkit makes it easier to deploy the SQL solution to the database server. This toolkit allows you to operate SQL Express, SQL Server 2000, and SQL Server 2005 databases locally, and then define your data And Data can be easily migrated and installed to a shared remote host SQL Server account.

SQL server hosting ToolkitClick here to download and install.The wizard also contains a database Publishing Wizard, which supports two Database Host deployment scenarios:

 

1) The database Publishing Wizard allows you to point to a database that you are operating on the local machine, and then automatically generate a. SQL script file that contains
The installation logic required to recreate a full copy of the current database on the remote system. This SQL script includes the need to create database definitions (tables, views, stored procedures, triggers, full-text index directories, roles,
Rules, etc ),
And all the things that fill the same data content as your local database into the new database (similar to the MySQL dump tool ). Encapsulate these installation logic in a single. SQL
The advantage of files is that most host providers already support uploading. SQL
File to their host environment, and the ability to run these scripts through their management control panel. Assume that you have a web host vendor that supports this function, and you can use the database to publish
You do not need to install or configure anything on the host provider.

2) database sending
The wizard also allows you to point to a database that you are operating on the local machine, and then use web service to migrate and recreate the database to your remote host environment (instead of creating a. SQL
File or use the management control panel of the host supplier to run this file ). However, this release option requires the host environment to provide SQL to publish web-service. SQL Server
The hosting toolkit contains a free web-service implementation for SQL release. We will work closely with the host supplier to deploy this web-service.

 

The database Publishing Wizard allows you to use SQL express or SQL Server 2000/2005 locally, and then use SQL 2000 or SQL 2005 in a remote host environment. ItNot RequiredThe SQL Server version is the same. Therefore, you can use SQL express 2005 locally and then upload it to the SQL 2000 server in the host environment without modifying any encoding.

More content can be found in: http://weblogs.asp.net/scottguAs you can see, there are also some tutorials. My favorite thing is that you can directly generate scripts in vs to generate all the data in the database, the same content as local data can be restored in a remote database.