''History Composer'' tool (part 4 of ''SQL History'' package)
$100-500 USD
Closed
Posted almost 21 years ago
$100-500 USD
Paid on delivery
The program to be developed is a part of a software package for working with "history scripts". The package is intended for database developers who need to deploy a database on their customers' machines (as a part of their software's installation process) and then update the database structure whenever a new version of their software is released.
The idea of a "history script" is that it keeps the SQL (required for creating and updating a database on customer's machine) in a number of versioned sections. A special update utility reads the script, executing only those sections needed to update the database from its current state. You can find details about the "history script" package and the script format in the .CHM file inside the attached ZIP.
The "history script" package will consist of several components for composing the scripts, executing them or embedding them into applications. The program you should develop in this project, "AdeptSQL History Composer", will be the "design-time" part of the package. The user should be able to create a new script (using templates specific for each DBMS) or open an existing one, add pieces of SQL code to the script as new sections, as well as do some other things described in the HTML document you will find inside the attached ZIP.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.
## Platform
The program must be written in Delphi 6. The source code should be well formatted (using the standard VCL-style formatting) and commented. All comments should be in English (no Russian, Chinese, etc)
The chosen coder will be provided with a component (THistoryPlayer) to parse and play history scripts. This component should be used in the Composer wherever appropriate.
It should be possible to use the Composer as either a stand-alone application or as a popup form in another program (AdeptSQL Workshop).
Therefore the coder should be:
* Experienced in UI design in Delphi,
* Be familiar with databases / SQL