Posted by metaperl on 06/24/06 12:34

Erland Sommarskog wrote:
> metaperl (metaperl@gmail.com) writes:

> >
> > My question then becomes: if I have a correct version, how easy and
> > with what approach would one take the data in the correct one and
> > mirror it to the poorly designed schema?
>
> I'm not really sure that I see the point with redesigning the
> data model, but then replicate the data to the old crappy version.

Because all of the ASP code is based on the wrong version of the
database.

> Or is the web site, only one consumer of the database? What if
> updates are performed from the web site?

Good point. That part of the website should definitely be rewritten to
send things to the correct database model.

>
> What you could do is to redo the data model, but then define views
> that mimicks the old tables.

Yes, this is what I concluded a day or two after posting this.

[Back to original message]