in reply to Perl denormalized-to-normalized schema translation, maybe with DBIx::Class (maybe)

The two data stores thing sounds like a disaster in the making. I think you are trying to bite off too much at once.

First carve out the CGI functionality into web services. For each web service, if you can convert all the CGIs that use that data at once, make the web service use a new data store. If you will convert the CGIs piecemeal, have that web service use the old data store, and switch to a new data store when the transition to that web service is complete.

A math joke: r = | |csc(θ)|+|sec(θ)| |-| |csc(θ)|-|sec(θ)| |