INFO: Data Tool Database Object Creation Not Available in VI 6.0

ID: Q195186

The information in this article applies to:

SUMMARY

The Visual InterDev 6.0 Professional package does not contain the ability to create database objects like database diagrams, tables, or stored procedures. This is a departure from Visual InterDev 1.0, where this was possible.

The functionality was moved to Visual Studio 6.0 Enterprise Edition. Visual InterDev 6.0, when installed from the Visual Studio 6.0 Enterprise Edition package, will have this capability.


MORE INFORMATION

The Visual Database Tools, a set of tools for accessing, viewing, and programming databases, have been enhanced in version 6.0. The tools now support Oracle schema design in addition to MS SQL Server, and have gained new capabilities, such as heterogeneous queries. They are also now available and integrated into all of the Professional Edition tools in Visual Studio, instead of just Visual InterDev, as in the previous version. To achieve these benefits, however, there were some changes to functionality.

When examining these changes, Microsoft found out that most mid- to large- sized programming shops were opposed to offering DBA-level capabilities to all of their developers. Also, a large percentage of customers divide responsibilities between database designers and application designers. It makes sense for the database designers to have the full range of Enterprise Edition functionality, and application designers to get the subset (at a reduced price) to be able to create applications around existing databases. Although this change doesn't apply to all customers, it balances the needs of most.

This change also makes the Visual InterDev Professional package more feature compatible with Visual Basic and Visual C++ Professional. These and other programs are bundled in the Visual Studio 6.0 Professional Edition.

A detailed feature comparison chart of the Visual Database Tools with various programs can be found at the following Web site:

http://msdn.microsoft.com/vinterdev/technical/VDTFeatureChart.asp


Keywords          : kbVisDBTools kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0; WINNT:6.0
Platform          : WINDOWS winnt 
Issue type        : kbinfo

Last Reviewed: May 7, 1999