Database is Pervasive SQL 2000i It was developed by Kodak and Practiceworks software runs on it ??" Practiceworks is used to manage a dental office. [login to view URL] We would like code to do the following: 1. Downloadable, self-extracting/installing executable to run on XP, NT, Server 2003 2. Run in the background (as a service?) 3. At a configurable time/date (monthly, weekly, daily) it will access the database and pull data from it (SQL commands) 4. The SQL commands that it executes should be stored in a text file that can be easily swapped out (updated etc.) 5. Then store the results in an ascii file, name it by date and location, and upload it to a FTP server. 6. Connections need to be secure over the web 7. The code will need to determine if a modem is in use or not and then upload appropriately I have a good deal of info about the data base (file names and column headings for most of the records. The databases are full of confidential information so we'd need to work around that. I can give you a copy of the install disks which would create an empty data base - perhaps you could work from that and then test it on the live data base on our machines? I can write most of the SQL query commands ??" though I may look for additional support here. I have a copy of the old database that I used your vi to access and I have a current copy that I can’t seem to get access to. 8. It should also log into the server and update a file every day ??" let us know that the code is still running ??" so we can write a html code to verify that last time it update (see if it is live)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
XP, NT, Server 2003