Topic: Solution for transferring records to new database
I have a project that from time to time I upgrade it, not only the software but also the database with new columns and tables, (with new relations between them). So my question is how can I transfer the existing records from the database to the new, without making the life of my customers difficult.
The only solution that I have is to create a small program all the time I make a change in the database that makes the job. The progress is simply I copy the "old" database in the folder of the program, that add the new tables and columns and transferring the data's and run the program using Sqlite script (my sqlite script is very poor) . After that I copy and paste the "new" database to the new upgraded software folder.
To avoid all this does anyone know a simply way. Keep in mind that it will be for my customers which they do not have an experience of programming