I have an application built with Delphi and I use UniDac with MySQL Database.
In version 1.0 I use a X number of tables and fields.
In version 1.1 I may add or remove some tables and/or remove fields of tables.
In version 1.2 I also add or remove fields/tables.
What I want is a universal system to check the database currently installed (ie version 1.0 software) and when the new version of application (ie 1.2) runs, to check the differences and update the database with changes of fields/tables.
Update can be done in any version for example from 1.0 to 1.3 or from 1.1 to 1.3 or from 1.2 to 1.3 or from 1.5 to 2.2 etc.
The system must detect all changes and update the database.
I am looking for a developer which already have implemented something similar and can help me to implement it in my software as well.
I dont care if it will be native delphi code (using UniDAC) or using an external command line application.
I just want something that works reliable.
I can give maximum 20$ (4 hours x 5$) + good review and rating.