Topic: General update question
I have a general update question about the database.
.
Lets have the following situation to make my question understandable.
.
1: You have created an application and give it to others (customers).
2: The others are using the application and enter a lot of data to the database.
3: You make a new version with changed database structure (more tables, more fields, changed fields, etc.).
4: The others are getting the new version and install/copy it over the old version. They keep their old database to keep the data they have entered.
.
The question is now:
.
1: Will the old database be keept unchanged and you (the persion who has created the application) must do all changes with SQL Statements.
2: The database will be updated with all changings.
3: The database will be rewritten and the others can say "goodbye" to their datas. In this case it would be needed to write a database backup as a dump and restore procedure and not as a simple copy of the database file.
.
Any experience for this szenario?
.
Thank you.
.
.
.
P.S. sorry for the dot-lines, but the forum does not accept empty lines I am entering...