• writing triggers on all tables would be little cumbersome and as said earlier would hit production.

    You can also think of implementing log shipping. keep log backup interval relatively higher and use this interval to study the data in ur developement database by bringing database in multi_user mode.. Hope u're not planning to enter data into developement simultaneously..



    Pradeep Singh