Skip to main content
Sign In |
  Help (new window)

MSF for CMMI Process Improvement

Go Search
Home
  
MSF for CMMI Process Improvement > Wiki Pages > Activity - Import Existing Database  

Activity - Import Existing Database

View All Site Content

Recent Changes
Activity Information

Import Existing Database

Create a Database ProjectImport Existing Database

Description

Oftentimes you will want to begin your database project by importing the database schema of an existing live database. This will allow you to import the schema object definitions and add them to the offline isolated file-based database project so they can be modified locally inside the project.

Roles

ResponsibleDatabase Administrator

Attributes

Element Categories[CMMI Track 2] Planning, [CMMI Level 3] PI SP 1.2
Entry Criteria
Database Project Created:
The database project is created.
Exit Criteria
Existing Database Imported:
An existing database is imported into the database project.
Is RequiredNo

Steps

  1. Import an Existing Database Schema Into the Database Project (Optional):

    Specify the source database connection with appropriately privileged credentials from which to import the database schema.

    Configure import options and decide whether to override current database configuration settings of your project with the source database settings.

Predecessors

TypeNameDependency Type
Create Database ProjectFinish-Start

Successors

TypeNameDependency Type
Configure Build and Deploy SettingsFinish-Start

Last modified at 12/19/2007 10:37 AM  by Administrator