sql project dll deploy

To generate a deployment script using generate scripts

1. OpenManagement Studio and connect to the SQL Server instance where themanaged 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 instancesof 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.