Is the RESTORE process dependent on schema?
- by Martin Aatmaa
Let's say I have two database instances:
InstanceA - Production server
InstanceB - Test server
My workflow is to deploy new schema changes to InstanceB first, test them, and then deploy them to InstanceA.
So, at any one time, the instance schema relationship looks like this:
InstanceA - Schema Version 1.5
InstanceB - Schema Version 1.6 (new version being tested)
An additional part of my workflow is to keep the data in InstanceB as fresh as possible. To fulfill this, I am taking the database backups of InstanceA and applying them (restoring them) to InstanceB.
My question is, how does schema version affect the restoral process?
I know I can do this:
Backup InstanceA - Schema Version 1.5
Restore to InstanceB - Schema Version 1.5
But can I do this?
Backup InstanceA - Schema Version 1.5
Restore to InstanceB - Schema Version 1.6 (new version being tested)
If no, what would the failure look like?
If yes, would the type of schema change matter?
For example, if Schema Version 1.6 differed from Schema Version 1.5 by just having an altered storec proc, I imagine that this type of schema change should't affect the restoral process. On the other hand, if Schema Version 1.6 differed from Schema Version 1.5 by having a different table definition (say, an additional column), I image this would affect the restoral process.
I hope I've made this clear enough.
Thanks in advance for any input!