How to: Change the Target Database Version
When you create a database project, you must specify the version of Microsoft SQL Server that you are targeting. You can create a database project for either SQL Server 2005 or SQL Server 2000. If you create a database project for SQL Server 2000, you can change the project to SQL Server 2005 because it can support all SQL Server 2000 features. If you create a database project for SQL Server 2005 and later must change the project to SQL Server 2000, you will experience difficulties if your project contains any syntax in the database object definitions that is specific to SQL Server 2005. In either case, errors might result if the version of SQL Server that is running on the target database server does not match the targeted version of the database project.
To change the target database version from SQL Server 2000 to SQL Server 2005
In Solution Explorer, click the database project for which you want to configure properties.
On the View menu, click Property Pages. You can also open the Project menu and click ProjectName Properties.
The properties dialog box for the database project appears.
Click the Project Settings tab if another tab appears instead.
In the Project Version list, click SQL Server 2005.
Important
You might also have to change the Target connection on the Build tab to point to an instance of SQL Server 2005. For more information, see An Overview of Database Project Settings.
On the File menu, click Save Selected Items.
The changes to your project properties are saved. The database project is reloaded, and any objects that fail validation for SQL Server 2005 are marked as invalid. You must manually fix any invalid object definitions. The next time that you build and deploy this database project, the generated build script will create or update a SQL Server 2005 database.
To change the target database version from SQL Server 2005 to SQL Server 2000
In Solution Explorer, click the database project for which you want to configure properties.
On the View menu, click Property Pages. You can also click ProjectName Properties on the Project menu.
The properties dialog box for the database project appears.
Click the Project Settings tab if another tab appears instead.
In the Project Version list, click SQL Server 2000.
Important
You might also have to change the Target connection on the Build tab to point to an instance of SQL Server 2000. For more information, see An Overview of Database Project Settings.
On the File menu, click Save Selected Items.
The changes to your project properties are saved. The database project is reloaded, and any objects that fail validation for SQL Server 2000 are marked as invalid. You must manually fix any invalid object definitions. The next time that you build and deploy this database project, the generated build script will create or update a SQL Server 2000 database.
See Also
Tasks
How to: Configure Database Projects for Build and Deployment
How to: Prepare Database Build Scripts
How to: Create Empty Database Projects
How to: Create Database Projects
Concepts
Terminology Overview of Team Edition for Database Professionals