Need a program written in Delphi that allows a user to select any two projects in Microsoft Project, then compares the various fields in each table through SQL statements and writes out the differences.
Does not need to be a ready for commecial release program. User interface can be extremely simple. Mainly looking for the guts of the program that will access the MS Project database and allow me to extract the data. I can complete the GUI and the report writing myself.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Program will consist of the following:
a.) Simple user interface that allows the user to choose any two projects in the MS Project database along with a Run button to start the comparisons when pushed.
b.) The program will compare 3 tables for differences which could be added or deleted records or changed field values through SQL statements and write specific fields for these added/deleted/changed records to a text file. Tables and fields will be specified after successful bid.
c) Speed is very important and would prefer direct SQL calls to the Microsoft database. However would consider dumping the entire database for the two selected projects to temporary tables for analysis.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Operating systems are Windows 2000 and Windows XP. Program must work with the latest version of MS Project and one version back.