UML for a migration.

[ScorpioTiger]

Hi Folks,

I'm fairly new to UML, but I'm trying to integrate it into projects as I get the opportunity.

Currently I'm working on a migration project and I'm using Enterprise Architect to document the target database including adding constraints. I then generate DDL to create a target database and write SQL by hand to populate the target.

I'd like to find a methodology that I can use to document the migration, and also get some ideas on how practical it would be to have the migration model driven.

Does anyone have any suggestions on how to approach this, or links to methodologies that others may have used to do this?

I appologise for what to some will seem like UML 101, but I don't yet know enough to know which questions to ask, so I've tried to keep it to what I'm trying to acheive.

Thanks in advance.

[Geert Bellekens]

ScorpioTiger,

Maybe you could explain a bit more about this "migration project" of yours.

"Migration" is a word that I've seen used in many different contexts.

Geert

[ScorpioTiger]

ScorpioTiger,

Maybe you could explain a bit more about this "migration project" of yours.

"Migration" is a word that I've seen used in many different contexts.

Geert

The project is to migrate data from one system to another. The systems provide similar functionality, but are implemented quite differently, so quite a lot of data transformation is required. Both the source and the target are RDBMs and I'm hand coding the migration using SQL.

I guess what I'm trying to determine is if there is some kind of framework or methodology that would allow me to document the data transformations at the most granular level. Presumably if this can be documented at the most granular level, then a model driven approach could not be far off.

In the event that I can't document at the most granular level, then some way that I can produce an abstraction that can be used to help understand the process would be of benefit.

Thanks...

[beginner]

There's a nice article about data mapping on the community site. Check it out.

b.