Thursday, January 12, 2012

Let a new nightmare begin

So I am gearing up to re-write an application that is well over 10 years old. During this process we have chosen to clean up the database as well, and this is where I started looking. During my research I found that the application as over 230 tables available to it, of those 112 are never referenced in code (remember – during that time “in-line SQL” was a big benefit). In continuing the research, I discovered that 83 of the 112 are never referenced in stored procedures either – and most of them had data in them. So I have these tables with data but without any interaction with the application. To make matters worse, 82 tables – both reference and not referenced in code – have no data in them. So this is my new nightmare.

No comments: