Skip to content

publish-a-database-sql-server-management-studio.md

Latest commit

 

History

History
34 lines (23 loc) · 1.55 KB

publish-a-database-sql-server-management-studio.md

File metadata and controls

34 lines (23 loc) · 1.55 KB
title Publish a Database (SQL Server Management Studio)
description Publish a Database (SQL Server Management Studio)
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 07/12/2021
ms.service sql
ms.topic conceptual

Publish a Database (SQL Server Management Studio)

[!INCLUDE SQL Server] You can use the Generate and Publish Scripts Wizard to publish an entire database or individual database objects to a Web hosting provider.

Note

The functionality described in this topic used to be provided by the Publish Database Wizard. The publishing functionality has been added to the Generate and Publish Scripts Wizard, and the Publish Database Wizard has been discontinued.

Generate Scripts Wizard

The Generate Scripts Wizard can be used to create a script for transferring a database.

To publish a database

  1. In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. Follow the steps in the wizard to script the database objects.

  2. On the Choose Objects page, select the objects to be published.

  3. On the Set Scripting Options page, modify script with Advance options, then select Save as script file.

See Also

Generate Scripts (SQL Server Management Studio)
Copy Databases to Other Servers