Exploring the Database Project
• In the Solution Explorer window, you can see the database project you’ve just created.
• Like all other projects in Visual Studio, this project can be added to Source Control, such as Visual
SourceSafe or TFS Source Control.
- Additional projects can be added to this solution if needed for database design.
• Notice that all the database schema objects are ordered by their types (Functions, Tables, etc.)
- Remember, you chose this view in the wizard dialog options.
• Each schema object is represented by an SQL file that can be used to create it.
- For example, you can see the SQL script that can create the AWBuildVersion table.
• You also have a new window called Schema View, opened via a link at the top of the Solution Explorer.
• This view organizes the objects based on the object types rather than the files.
- Keep in mind that it’s just a different view of the same database objects.
- The Schema View may be a more intuitive way to view all the database objects.
• The only difference between the two windows (as far as capabilities are concerned) is renaming.
- In Solution Explorer, you can rename an individual SQL file.
- In Schema View, you can rename a database object and update all objects referencing that object; this is
known as database refactoring.
• The objects can also be filtered based on the database’s schemas as well by clicking on “Filter Schema
View”.
- This is an alternative way of opening the database objects.
- These schemas were already defined in the database and should not be confused with your project
database schemas.
• Be sure to refresh the view periodically, in case changes were made to the SQL scripts on the Solution
Explorer window.
- Remember that this project is an offline representation of an existing database.
- Changes to the original or new database aren’t deployed until you decide.
- The Schema View window also includes a handy link to bring back the Solution Explorer.
• The project properties window (accessible through Project – Properties) exposes variables that affect
its runtime behavior and build settings.
• Note that different settings are available using the tabs on the left side.
- Some of these properties are the same ones that you chose when you stepped through the wizard.
• In the Solution Explorer window, you can see the database project you’ve just created.
• Like all other projects in Visual Studio, this project can be added to Source Control, such as Visual
SourceSafe or TFS Source Control.
- Additional projects can be added to this solution if needed for database design.
• Notice that all the database schema objects are ordered by their types (Functions, Tables, etc.)
- Remember, you chose this view in the wizard dialog options.
• Each schema object is represented by an SQL file that can be used to create it.
- For example, you can see the SQL script that can create the AWBuildVersion table.
• You also have a new window called Schema View, opened via a link at the top of the Solution Explorer.
• This view organizes the objects based on the object types rather than the files.
- Keep in mind that it’s just a different view of the same database objects.
- The Schema View may be a more intuitive way to view all the database objects.
• The only difference between the two windows (as far as capabilities are concerned) is renaming.
- In Solution Explorer, you can rename an individual SQL file.
- In Schema View, you can rename a database object and update all objects referencing that object; this is
known as database refactoring.
• The objects can also be filtered based on the database’s schemas as well by clicking on “Filter Schema
View”.
- This is an alternative way of opening the database objects.
- These schemas were already defined in the database and should not be confused with your project
database schemas.
• Be sure to refresh the view periodically, in case changes were made to the SQL scripts on the Solution
Explorer window.
- Remember that this project is an offline representation of an existing database.
- Changes to the original or new database aren’t deployed until you decide.
- The Schema View window also includes a handy link to bring back the Solution Explorer.
• The project properties window (accessible through Project – Properties) exposes variables that affect
its runtime behavior and build settings.
• Note that different settings are available using the tabs on the left side.
- Some of these properties are the same ones that you chose when you stepped through the wizard.
Database Project
Table of Contents
Copyright (c) 2008. Intertech, Inc. All Rights Reserved. This information is to be used exclusively as an
online learning aid. Any attempts to copy, reproduce, or use for training is strictly prohibited.
online learning aid. Any attempts to copy, reproduce, or use for training is strictly prohibited.
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Courseware
Training Resources
Tutorials