DB2 Version 9.7 for Linux, UNIX, and Windows

DB2 integration in Visual Studio

The IBM Database Add-Ins for Visual Studio are a collection of features that integrate seamlessly into your Visual Studio development environment so that you can work with DB2® servers and develop DB2 procedures, functions, and objects.

IBM Database Add-Ins for Visual Studio are designed to present a simple interface to DB2 databases. For example, instead of using SQL, the creation of database objects can be done using designers and wizards. And for situations where you do need to write SQL code, the integrated DB2 SQL editor has the following features:

Colored SQL text for increased readability
Integration with the Microsoft Visual Studio IntelliSense feature, which provides for intelligent auto-completion while you are typing DB2 scripts

With IBM Database Add-Ins for Visual Studio, you can:

Open various DB2 development and administration tools
Create and manage DB2 projects in the Solution Explorer
Access and manage DB2 data connections from the Server Explorer
Create and modify DB2 scripts, including scripts to create stored procedures, functions, tables, views, indexes, and triggers

Following are the means by which IBM Database Add-Ins for Visual Studio can be installed on your computer.

Visual Studio 2005, 2008 and 2010: The IBM Database Add-Ins for Visual Studio are included as a separately installable component with the DB2 Client and the DB2 servers. Once you are finished installing your DB2 product, you will be presented with an option to install the IBM Database Add-Ins for Visual Studio. If you do not have Visual Studio installed on your computer, the add-ins will not install. Once you install Visual Studio, you can then install the add-ins at any time from the DB2 product's setup menu.
Important: Visual Studio 2005 support has been deprecated and might be removed in a future release. Start using Visual Studio 2008 or later. For more details, see Visual Studio 2005 has been deprecated.

For more details about using the IBM Database Add-Ins and the Data Server Provider for .NET for rapid application development, visit the IBM Information Management and Visual Studio .NET zone at http://www.ibm.com/developerworks/data/zones/vstudio/index.html.