Overview of Visual Database Tools
Visual Studio .NET 2003
You can access Microsoft Visual Database Tools from your development environment to help create and manage data-driven applications that use data in databases such as Microsoft SQL Server and Oracle.
Note Visual Database Tools work only with Microsoft SQL Server and Oracle databases. The available features depend on your version of Visual Studio. For more information, see Visual Database Tools Editions.
In This Section
- What's New in Visual Database Tools
- Describes new and improved features of Visual Database Tools: SQL Server 2000 support, create scripts, database project changes, and user interface improvements.
- Visual Database Tools Components
- Provides links to descriptions of each of the tool and designer available in Visual Database Tools.
- Work You Can Do with the Visual Database Tools
- Learn how Visual Database Tools can help you design, query, and manage your database.
- Relationship Between Visual Database Tools and Databases
- Understand how Visual Database Tools interact with your database while retaining your work in memory and supporting multiuser environments.
- Database Connections and Database References
- Examines similarities and differences between database connections in Server Explorer and database references in Solution Explorer.
- Database Development and Visual Database Tools
- Provides an overview of the tools included and how to manage large database projects.
- Database Queries and Visual Database Tools
- Explains concepts behind creating queries and views of your data in Visual Database Tools.
- Developing Database Structure
- Gives detailed steps for designing and maintaining database structure through tables, columns, keys, indexes, stored procedures, and more.
- Designing Data Retrieval and Manipulation
- Provides links to topics with details on how to design queries and views as well as how to modify data.
- Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.