Share via


SQL Server 2005 Deployment

Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. This means that you can now write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
Data Deployment: Streamline Your Database Setup Process with a Custom Installer Data Deployment: Streamline Your Database Setup Process with a Custom Installer
MSDN Magazine columnist Alek Davis presents a general approach to writing database installers and illustrates it with a real-life example. The article is accompanied by helper scripts, which can be used for setting up databases and compiling T-SQL scripts.

Articles and Columns

Managing and Deploying SQL Server Integration Services
SQL Server Integration Services (SSIS) is an enterprise-level data integration platform. SSIS is an entirely new subsystem in SQL Server 2005. This paper tells you how to take advantage of the SSIS management and deployment features.

Webcasts

In This Section

  • Installing SQL Server 2005
    Get guidance from the SQL Server 2005 Books Online for planning and executing your SQL installation.
  • Migration, Upgrade and Interoperability
    Find resources to help you interoperate SQL Server 2005 with other systems, upgrade earlier versions of SQL Server to SQL Server 2005, or migrate from another database platform to SQL Server 2005.

Resources in the SQL Server Books Online

More...