Reverse engineer a database

Reverse engineering is what we call the process that takes a given database and turns it into a model driven “thing”.

Reverse eod.png

You just need to give a valid connection string to it;

in this case a use the MusicStoreDb from a MicrosoftSample:

Reod.png

You start by Analyzing the database:

Analyzing the database.png

And then you “Go!” – be aware of that this process will empty the package you started from and fill it with the stuff from the reverse engineer process:

Erase package.png

Giving us this in the modlr tree:

Package list.png

And I will drag these classes out on a diagram to get this:

Diagram reod.png

And that is enough information to run the model against the exact same database as we reversed it from:

Run the model.png

Giving us a way to use the trusty AutoForms and EcoSpaceDebugger to look at the changeble data :

EcoSpacedebugger.png

In this particular database the RecordId, ArtistId and sofort are of type int in the database and are designed with “Is Identity==true” in SqlExpress. Also the “Identity Increment” is set in SqlExpress.

The Reverse algorithm gave us a model with int Attributes for the ID – we want ECO to be able to use that Key scheme instead of the standard ECO_ID :

Use that Key scheme instead of the standard ECO ID.png
This page was edited 88 days ago on 02/11/2024. What links here