Deployment and Testing: Visual Studio and SQL Server

When you’re done with the code development, you need to deploy the assembly and the routines into a SQL Server database:

  • Build the project into an assembly–a .DLL file on disk with the Intermediate Language (IL) code.

  • Deploy the assembly into a SQL Server database. The IL code is loaded from the .DLL file into the database, and after the load, you no longer need the external file.

  • Create routines (functions, stored procedures, and triggers) in the SQL Server database. This process essentially registers routines from the assembly, which already resides in the database.

All these steps can be achieved from Visual Studio with an automated process if you’re working with the SQL Server Project template. ...

Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial