#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    soCAL
    Posts
    198
    Rep Power
    26

    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?
  2. #2
  3. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2004
    Posts
    1,124
    Rep Power
    158
    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.

    Dopes
    I am nothing now
    and I'll be nothing when
    this nothing world
    has it's nothing end.
    -- Violent Femmes

IMN logo majestic logo threadwatch logo seochat tools logo