i have database replication system setup in production db gets copied reporting db every 24 hours. i'm wondering how can make work when production database schema gets upgraded (new tables, different number of columns per table, etc.) in case, still want preserve in reporting database yet adapt changes in schema. there standard procedure this?
Comments
Post a Comment