Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Performing Iterative Database Development

After you put your database or server under version control and define a testing baseline for your project, you and your team spend most of the development cycle performing various iterative development tasks. Each of these tasks includes a few simple steps:

  • Understand the task.

  • Synchronize your development environment.

  • Check out files, and make the necessary changes to the database project or the server project.

  • Refactor the code and data.

  • Build and deploy the project into your isolated development environment.

  • Test your changes, which might include generating test data.

  • Analyze the new or modified code to identify potential problems.

  • Check in your changes to share them with the team.

  • Troubleshoot any issues.

In the following table, you can find descriptions of common tasks that support this scenario and links to more information about how you can successfully complete those tasks.

Task

Supporting Content

Identify and understand the task: In a team environment, your work often corresponds to a work item in Visual Studio Team System Team Foundation Server. After you find and understand the work item, you might need to learn about the code that you will be changing.

Querying for Work Items

Synchronize your development environment: Before you begin a task, you might need to get the current version of the project from version control. If changes were made to the production or staging server that are not reflected in the project, you might need to update the project before you begin your development task.

How to: Get the Source for Your Team Project

How to: Update File Versions in Your Workspace

How to: Import Updates from a Database into the Database Project

Modify the objects, settings, or scripts for the project: To complete the development task, you typically must modify objects, settings, or scripts in the database or server project.

Scenario: Create and Modify Database and Server Objects

Scenario: Create and Modify Database Scripts

How to: Add Existing Items to a Database Project

How to: Exclude Files from a Database Project

Refactor the code and data in the database or on the server: You can use database refactoring to eliminate some repetitive and error-prone tasks, such as renaming all references to an object, fully qualifying names, expanding wildcard characters, or moving an object to a different schema.

Refactor Database Code and Data

Build and deploy changes to your isolated development environment: After you modify the project, you build and deploy the changes to your isolated development environment. You can test your changes in isolation before you share them with other team members.

Build and Deploy Databases to an Isolated Development Environment

Test your changes: You can run existing unit tests against the modified database or server to verify that your changes do not break any behavior of your application. You can also create unit tests to verify new or changed behavior. You might need to change your data generation plan to support new or changed unit tests. You might also want to update your isolated development environment with data from a test, staging, or production server.

Run Database Unit Tests

Create and Define Database Unit Tests

Generate Test Data for Databases by Using Data Generators

Compare and Synchronize Data in One or More Tables with Data in a Reference Database

Identify potential issues by analyzing your code: You can analyze your database code to find and fix common design, naming, and performance issues. For example, you can find database code that might cause a table scan when you run it.

Improving Database Code with Static Analysis

Check in your changes: After you test your changes and analyze the code for potential problems, you can check your changes in to version control so that you can share them with your team. When you check in your changes, you must also resolve any related work items.

How to: Add a Project or Solution to Version Control

Using the Check In and Pending Changes Windows

How to: Check In Pending Changes

Troubleshoot common project, build, or deployment issues: You can learn how to resolve common problems that you might encounter when you work with database and server projects, such as when you build or deploy them.

Troubleshooting Database Project, Build, and Deployment Issues

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft