The database project gives you a way of organizing and distributing SQL Server scripts.

When a script is run or debugged, it uses the database connection defined in the project as the default database, but the scripts can be run on any SQL Server database. Stored procedures are compiled and saved inside the SQL Server database. The scripts are saved as disk files and are external to any database. It is very important to make the distinction between these scripts and stored procedures. There are two subfolders in the project for storing change scripts and another for queries. Solution Explorer view of a database project. You should find it under the Other Projects node of the tree control ( Figure 3.22).įigure 3.22. When the new project dialog opens, find the template called Database Project. Select New Project from the File menu, or if you are adding it to an existing solution select Add Project/New Project. You can also add one to an existing solution. You create a database project the same way you create any other new VB project. NET supports neither of these tools, its database project is used to manage SQL queries and scripts. The VB 6 database project was a template for creating a project with a DataEnviroment designer and a DataReport designer precreated. However that type of project was very different.

Visual basic data base