34,838
社区成员
发帖
与我相关
我的任务
分享如何手工部署clr程序集（dll）
用studio生成的dll如何手工部署到sql server数据库，部署脚本怎么写，怎么执行，开发的时候studio自动部署的，想交付到生产环境，需要部署脚本，请教大虾们！！！
...全文
请发表友善的回复…
发表回复
7761098 2009-10-27
- 打赏
- 举报
建議如果經常要部署的話還是升級去2008吧，那個部署流程更簡單方便
superjj2002 2009-10-27
- 打赏
- 举报
搞定了，果然是先注册dll，然后用生成的脚本去create procedures
superjj2002 2009-10-27
- 打赏
- 举报
是需要先用CREATE ASSEMBLY from dll去创建程序集吗？
如果是存储过程，还需要手工创建一下吗？手工创建是不是就是指执行上述步骤生成的脚本？
如果是存储过程，还需要手工创建一下吗？手工创建是不是就是指执行上述步骤生成的脚本？
superjj2002 2009-10-27
- 打赏
- 举报
To generate a deployment script using generate scripts
1.Open Management Studio and connect to the SQL Server instance where the managed assembly or database object to be deployed is registered.
2.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.
3.Select the database from the list box and click Next.
4.In the Choose Script Options pane, click Next, or change the options and then click Next.
5.In the Choose Object Types pane, choose the type of database object to be deployed. Click Next.
6.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.
7.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.
这是官方的部署步骤，这时候开发机上已经有存储过程了，导出的脚本，在生产机上执行的时候，如何和dll文件想关联？这个脚本不需要编译成的dll文件了吗？
1.Open Management Studio and connect to the SQL Server instance where the managed assembly or database object to be deployed is registered.
2.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.
3.Select the database from the list box and click Next.
4.In the Choose Script Options pane, click Next, or change the options and then click Next.
5.In the Choose Object Types pane, choose the type of database object to be deployed. Click Next.
6.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.
7.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.
这是官方的部署步骤，这时候开发机上已经有存储过程了，导出的脚本，在生产机上执行的时候，如何和dll文件想关联？这个脚本不需要编译成的dll文件了吗？
