I have a general design/strategy doubt. Suppose i have taken a backup of the DB some days back. Now i have added a column in a table of the DB and my bussiness layer is also using that value. Now i want to restore the old backup which i had taken. Will it conflict since the present schema is different?. In this case whats the approach? should there be some mapping with DB versions and Bussiness layer version or something similar. I would like to know the ideal design approach here.
If you restore the backup then that is a complete replacement of the database, to the version that is included in the backup - i.e. you will lose the column. And all the changes you have made (additions, deletions, updates) since. Presume you are wanting to restore to retrieve some old data? To get round the issue now, restore the database to a different name, and copy the data that you need. What I'm confused about is you asked about the 'design approach' - do you want to be able to do this regularly?