sql project dll deploy

最新推荐文章于 2024-10-16 17:36:30 发布

tonglanli

最新推荐文章于 2024-10-16 17:36:30 发布

阅读量384

点赞数

分类专栏： Sql 文章标签： dll sql database object deployment types

本文链接：https://blog.csdn.net/tonglanli/article/details/5285090

版权

3 篇文章 0 订阅

订阅专栏

To generate a deployment script using generate scripts

Open Management Studio and connect to the SQL Server instance where the managed assembly or database object to be deployed is registered.
In the Object Explorer , expand the <server name> and Databases trees. Right-click the database where the managed database object is registered, select Tasks , and then select Generate Scripts . The Script Wizard opens.
Select the database from the list box and click Next .
In the Choose Script Options pane, click Next , or change the options and then click Next .
In the Choose Object Types pane, choose the type of database object to be deployed. Click Next .
For every object type selected in the Choose Object Types pane, a Choose <type> pane is presented. In this pane, you can choose from all the instances of that database object type registered in the specified database. Select one or more objects and click Next .
The Output Options pane comes up when all of the desired database object types have been selected. Select Script to file and specify a file path for the script. Select Next . Review your selections and click Finish . The deployment script is saved to the specified file path.