Database Publishing Wizard

SQL Server 2007. 9. 12. 16:42

Data까지 스크립트로 생성할 수 있다!! 오~

출처 : http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Overview

SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window. If supported by the hosting service provider, the Database Publishing Wizard can also directly upload databases to servers located at the shared hosting provider.

Optionally, SQL Server Database Publishing Wizard can integrate directly into Visual Studio 2005 and/or Visual Web Developer 2005 allowing easy publishing of databases from within the development environment.

Top of page

System Requirements

Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP

Required software: SQL Server Database Publishing Wizard requires the following components to be installed:
- Microsoft .NET Framework Version 2.0 Redistributable Package (x86)
- Microsoft SQL Server 2005 Management Object Collection, available within the Feature Pack for SQL Server 2005
Optional software: SQL Server Database Publishing Wizard can optionally integrate with either Visual Studio 2005 (Standard and higher) and/or Visual Web Developer 2005

Top of page

Instructions

Install any required components from above that have not already been installed
Click the Download button on this page to start the download
Install the SQL Server Database Publishing Wizard by selecting the Run option

Top of page