Click here to Skip to main content
15,891,253 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,

How to preserve MS Access database while upgrading the software..

using custom installer or do we have any idea.

Currently My software is using .mdb file.

How to preserve the client data in the ms access database while upgrading the software in the C#

Thanks
Vijay r
Posted

1 solution

How upgrading of the software can disrupt your data? It should not. You need to keep your software backward-compatible.

You can do perform some schema evolution, but you need to keep the schema backward-compatible by making only incremental steps in evolution. That's it, you should not remove anything from schema, only add.

If you want to migrate from some entities you want to get rid of to some new entities, do not remove old ones anyway. Instead, in the code, create some mechanism of deprecation. When your user starts some new work (hard to say what it can be based on your information, maybe you don't have suck thing), the code should use new entities, but if the user queries for something created before the schema evolution, old entities should keep working.

This is all I can say based on your rather minimalistic information.

See http://en.wikipedia.org/wiki/Schema_evolution[^].

—SA
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900