Managing IBM Database Projects

The IBM^® Database Add-Ins for Visual Studio include an IBM Database Project type for Visual Studio. The IBM database project is designed specifically for working with files that can be run on IBM data servers. You can manage the IBM database project in the Visual Studio environment with other projects in the Solution Explorer.

With an IBM database project, you can:

Add new or existing files to create the following IBM database routines and objects:
- SQL or SPL procedures
- for Linux^®, UNIX^®, and Windows^®: DB2^® CLR procedures
- SQL or SPL functions
- Tables
- Indexes
- Views
- Triggers
Add new or existing scripts to perform database queries or any other supported IBM database DDL, DCL, and DML statements.
Build routines and objects in the project.
Perform common tasks such as setting project dependencies, setting the item build order, setting project build order, and working with source code control systems.

Note: DB2 projects that you created in the IBM Database Add-Ins for Visual Studio 2005 - Fix Pack 2 and earlier releases have the full range of functionality that is available for IBM database projects. The extensions of the script files in an IBM database project have an "ibmdb" prefix (for example, .ibmdbtbl and .ibmdbsp). However, the extensions of the script files in your DB2 project retain their "db2" prefix (for example, .db2tbl and .db2sp).

In this section:

Creating IBM Database Projects: Instructions for adding a new IBM Database Project to your solution.
Changing IBM Database Project Properties: Instructions for changing the properties of an IBM database project.
Adding an IBM Database Solution to the Source Control System: Instructions for using the source control system and IBM Database solutions.
Setting the Item Build Order: Instructions for setting the item build order.
Selecting Project Files for Ordering: Instructions for ordering files in the order in which you want them built.

In this section:

See Also