We are migrating SD from 12.7 to 12.9. So we planned to restore 12.7 db backup to 12.9.
During this restore activity time SD 12.7 service will not be stopped as there will be a large impact stopping SD service. So once the restore activity got completed, next will be loading the tickets to SD 12.9 which got raised during the activity time.
I know cr,chg,act,iss ,act and other related tables need to be extracted. But how to achieve this and what is the standard procedure to be followed.
Looking for some help. Please guide.