Friday, April 13, 2007

DB2 integration in Visual Studio

The IBM Database Add-Ins for Visual Studio 2003 and 2005 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. These add-ins 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 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 (in Visual Studio 2005 you can do this from the
    Server Explorer; in Visual Studio 2003, you can do this from the IBM 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 2003

The IBM Database Add-Ins for Visual Studio 2003 are included with the DB2 Client and the DB2 servers. The DB2 installation detects the presence of Visual Studio 2003, and if it is installed, the add-ins are registered. If you install Visual Studio 2003 after you install a DB2 product, run the "Register Visual Studio Add-Ins" utility from the DB2 instance's start menu.

Visual Studio 2005

The IBM Database Add-Ins for Visual Studio 2005 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 2005. If you do not have Visual Studio 2005 installed on your computer, the add-ins will not install. Once you install Visual Studio 2005, you can then install the add-ins at any time from the DB2 product's setup menu.





Read more here: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.ms.doc/doc/c0010780.htm

No comments: