I have two database server A and B. They are identical, and the databases are identical. Now I want to upgrade B, adding a lot of schema changes....etc. server A still up and running doing production. The database upgrade process will take 1 day.
After B upgrade is completed, I want to take A database snapshot from A then restore to B so that B and A in data are merged and consistent. No missing data. I don't know if this can be doable?? Please advice