Datasheet

26
Database Development Tools
Use the Database Development tools to create and
maintain databases and manage data-driven
applications
Database Schema Build & Deployment Tools to
deploy a new database, or changes to an existing
database, from your database project to a database
server
♦
♦
Database Unit Testing to establish a baseline state
for your database and then to verify any subsequent
changes you make to database objects
♦
♦
Offline Database Schema to make database schema
changes in an isolated development environment
♦
♦
Project Version to change the database project
between SQL Server 2000 and SQL Server 2005
♦
♦
Schema Compare to compare the schemas of two
databases and then decide whether to apply some or
all schema objects from the source to the target
♦
♦
SQL Server 2000 project template to create a project
that represents a Microsoft SQL Server 2000
database schema
♦
♦
SQL Server 2000 Wizard project template to
automate creating a SQL Server 2000 database
project, optionally importing a schema from a
database, and configuring your build settings
♦
♦
SQL Server 2005 project template to create a project
that represents a Microsoft SQL Server 2005
database schema
♦
♦
SQL Server 2005 Wizard project template to
automate creating a SQL Server 2005 database
project, optionally importing a schema from a
database, and configuring your build settings
♦
♦
T-SQL Editor to modify definitions of database
objects such as tables, views, indexes, stored
procedures, etc
♦
♦
Code Analysis Tools
Use the Code Analysis tools to analyze your source
code for potential issues arising from common coding
errors
Auto-Suppress Generated Code Option to
automatically suppress error messages from
generated code, which is especially useful for
designer-generated code
♦
♦