We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this?
I was planning for triggers on Old file and the New one. How do i control triggers calling each other ?