Db2 integration in Visual Studio

The IBM® Database Add-Ins for Visual Studio component is a collection of IBM database development features that integrate seamlessly into your Visual Studio development environment.

The IBM Database Add-Ins for Visual Studio component presents a simple interface to IBM databases. For example, you can create database objects with the designer and wizard tools instead of SQL statements. You can use the integrated Db2 SQL editor to write SQL statements. The Db2 SQL editor contains 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
You can perform following tasks with the IBM Database Add-Ins for Visual Studio component:
  • 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.
Visual Studio 2019, 2017, 2015, 2013, and 2012
The IBM Database Add-Ins for Visual Studio component is included as a separately installable component that can be installed after IBM data server client product is installed. Your environment must already have the Microsoft Visual Studio software installed or installation of the IBM Database Add-Ins for Visual Studio component cannot be completed successfully.
Attention: The IBM Database Add-Ins for Visual Studio component is not supported by all editions of Microsoft Visual Studio software. You must ensure that the edition of Microsoft Visual Studio software you are using supports the use of external Add-Ins.
Important: Starting in Db2 10.5.0.5, the use of IBM data server products with Microsoft Visual Studio 2008 is deprecated.

You can download the IBM Database Add-Ins for Visual Studio product for different Db2 versions and fix packs from the Download Db2 Fix Packs by version for Db2 website. .