Artifact: Data Migration Specification

This artifact contains the data profile of the data sources that will be migrated and the mapping between the data sources and the target database.

Domains: Analysis and Design
Work Product Kinds: Specification

Purpose

The main purpose of this artifact is to describe data sources to be migrated and to specify the mapping between the source data and the target data. It will be used by the Designer to design any automated data migration software components.

Relationships

Roles	Responsible: Database Designer	Modified By: Database Designer
Tasks	Input To: Subsystem Design Subsystem Design (SOA)	Output From: Specify Data Migration

Description

Brief Outline

1. Introduction

Scope of the migration

2. Data Profile

Data Systems
Data Attributes Profile
Data Attribute Dependencies

3. Data Mapping Table

Tailoring

Representation Options

UML Representation: Not Applicable.

The Data Profile can include or reference a Data Model, if a Data Model exists. Manually created/maintained data models may need to be updated to correctly reflect the current data. It may also be helpful to create a data model by reverse engineering. For more information, see Guideline: Reverse-engineering Relational Databases.