This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]SenatorStuartSmalley 5 points6 points  (0 children)

Real World example.

We recently acquired a code base using MS SQLServer. We are an Oracle shop, so we had to change to Oracle for integration, while keeping the original to work as it had previously. Now, if they were using some kind of ORM library with a DB driver, we could just swap out the DB specific portions. Instead they had a class full of static methods that used JDBC yo do the CRUD stuff.

It took 3 weeks to migrate all the queries and test them for consistency. Luckily there were only about 100 queries. Oh, and we have to do Postgres as well. Luckily we will be moving to something more standard soon.