August 11th, 2004, 12:42 AM
How to accomodate changes in source code after altering the database.
Say you have a pretty big database and you change a few of the tables (say take out an attribute or two), how do you go back to your source code to fit the changes? Esp when you think you might have a lot of files accessing the tables you have changed. I've heard Toad actually tells you which tables have been accessed by what files. Do other programs do the same?
August 11th, 2004, 06:00 AM
If you're using any kind of database abstraction layer, you could modify the query method to keep a log of tables and columns accessed (along with the page).
Seems like if the column names are unique enough, a simply "find in files" would suffice to finding them all. Depends upon your source code, though.
Depending upon your database, you could just enable logging within it, also, and see what's being accessed there.
I am nothing now
and I'll be nothing when
this nothing world
has it's nothing end.
-- Violent Femmes