Re: Change of Logging Status: Implications?

Richard Spitz wrote: > So I need info about the implications of changing a database to logging > mode. What problems are to be expected in what parts of a program? I'll > have to assist the developer throughout the migration process, without > knowing too much about the program itself and the database involved. If > I did know, I'd probably quit my job as DBA... These problems have grown > historically without me having had much influence, so please refrain > from comments like "you should have known better". I just have to save > as much as possible. > > Answers like "RTFM" are welcome as long as the tell me which FM to R. If you are really in a hurry, a great RAD technique is to set up a development environment with a logging database and hack (er, modify) the application until it works. This will give you are far better insight into what the implications of logging are than R'ing any FM. That's of course IMO. No, I didn't forget the H, I just love TLA's. This is fine for standard maintenance type programs. If yours is more complex then testing this kind of hack (er, modification) can get tricky. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+