Rollback database migration saving changes
Hi All,
We are planning to migrate our production database from one location to another.
We are still in planning phase and I need a suggest for one of the possible scenarios we have considered:-
Suppose on at DAY 1 ,we copy database from old location to new location.And old database is closed after copy process is complete and new database is in action.
Now new database is under operation and all the new transactions affect new database.
Now at DAY 10, we find that there is XYZ problem and we want to move back to the old database .In this case we have to move all the "changes" from newer to the older database and bring it up.
So my question is : Is it possible to apply achived logs for 10 days of period from the newer database to the older one???
If my question is not clear to you please ask..
Please suggest for both cases of database upgrade and migration for same version.
Please reply..
Thanks in advance..
Saket Bansal