Alexander Foken wrote: <snip>
You could slowly migrate your system, a first step would be to make sure all table and column names match /^[A-Za-z][A-Za-z0-9_]+$/. Next, move the tables and the business logic to a "real" database. Then finally, get rid of ODBC drivers and Access on the clients and switch to a web frontend using a native driver like DBD::Oracle or DBD::Pg.
That is what I am going to do. The guy that built the original had one foot out the door and the more I look at what he did the harder it is to keep from barfing.
I am going to redo the schema a bit and just migrate the actual data over. We have an ent. license for Oracle so I may as well use it.
Robert
