Microsoft SQL Server 数据库自动部署工具

worker321

　　微软的一个东西,可以帮助你快速部署SQL server 数据库.
Microsoft SQL Server Database Publishing Wizard 1.0 Release Candidate
　　链接:
　　http://www.microsoft.com/downloads/details.aspx?FamilyID=52d6e741-a4e9<chmetcnv w:st="on" tcsc="0" numbertype="1" negative="True" hasspace="False" sourcevalue="4" unitname="ac">-4ac</chmetcnv>5-9877-f4bc0bd06b55&DisplayLang=en
下载地址:
http://download.microsoft.com/download/<chsdate w:st="on" isrocdate="False" islunardate="False" day="6" month="6" year="2004">4/6/6</chsdate>/46662831-1407<chmetcnv w:st="on" tcsc="0" numbertype="1" negative="True" hasspace="False" sourcevalue="429" unitname="C">-429c</chmetcnv>-8fee-ce9db<chmetcnv w:st="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="232" unitname="C">232c</chmetcnv>042/Database%20Publishing%20Wizard%201.0%20RC.msi

功能描述:
　　
The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.

The tool supports two modes of deployment:　　

• It generates a single SQL script file which can be used to recreate a database when the only connectivity to a server is through a web-based control panel with a script execution window. 　　
  
  
• It connects to a web service provided by your hoster and directly creates objects on a specified hosted database 　　
  
  

The Database Publishing Wizard provide both a graphical and a command-line interface. In addition, it can integrate directly into Visual Studio 2005 or Visual Web Developer 2005.
中文描述:
数据库发布向导
提供两个功能:

• 自动生成一个SQL脚本,它可以用来在一个sql服务器上生成一个当前的数据库,包括表,存储过程,以及当前数据库中的数据. 相当于数据库的安装软件.
  
• 可以用一个web service 来在新服务器上生成你的当前数据库,这样连sql脚本也省略了.