Project :
Todays our application program work with access on a local network (10 persons). We need to transfer our database on my MySQL for better performance. 30 persons will need to use the application in a near future on different sites in France. Therefore, we need to be able to use this database from anywhere via internet.
Your mission : realise the evolution of our database from Access to php/MySQL.
- Rebuild the structure of the database unde rphp/MySQL.
- Change strucutre of the database to function on multisite
- Use this database on a fullweb version
- Program changes of DAO connections to ODBC (open database connectivity connections).
- Optimize theSQL queries of the progrram
-Realise a new module, allowing the mportation of data using a .txt file, towards 2 tables. (1 already made + 1 to be created).
- Build automatic back-up system, every 1 hour.
- Build security of the program, starting from the existing one. Our security works thanks to Access ([login to view URL]) and it needs to be adapted on the new multisite system.
## 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).
* * *This broadcast message was sent to all bidders on Wednesday Jan 16, 2008 8:41:03 AM:
Hi, A version of our existing database has been dowloaded on a bid, and more information too. Regards, Pierre
* * *This broadcast message was sent to all bidders on Thursday Jan 17, 2008 1:02:17 PM:
The login of the datebase downloaded is : usr2ltp and password : kdeuqe3 Sorry for the mistake.
* * *This broadcast message was sent to all bidders on Wednesday Jan 23, 2008 9:17:08 AM:
We posted an UML plan of the project in attachment. Pierre
## Platform
Todays the operating system is runned on Access 2003, Windows XP.
The project must be build under php/MySQL