We have a Microsoft SQL database for a legecy system that its schema has more or less gone out of control. A fairly large number of delveopers from all over the world asked themselves if they could complicate it more and then of course did so.
I am trying to make since of it and automate tasks that are currently being done by hand. Part of that is chef, part of that is a rails app to orchestrate it all in friendly manner and other part is the database management.
I like the look of ActiveRecord and its function but it dosen’t appear to be to friendly for a situation such as mine. I cant change the db schema. The schema is also not consistent. The schema is also half plural.
Any suggestions? I would really prefer to be able to model the data using objects and then apply it. The data is fairly complex spread out over many tables.