Suljettu

Remote (web-based) Database Update Tool

I need a web page that will present the user with a button, and when the button is pressed, it will install a component on the client machine (or run the component if it is already installed), which will allow the client's database to be updated.

The website/server will have a MySQL database that will contain company tables, and within each company table it will have many fields, up to 20. The information must be pre-formatted into a specific table format, which will depend on the client's database table version on his local machine, and then will update the client's database entries if an entry exists, and insert those rows that do not exist.

----PLEASE NOTE: DESCRIPTION UPDATED----

I require a web page that will have a login page and when logged in it will present the user with a button, and when the button is pressed, it will install a component on the client machine (or run the component if it is already installed), which will update the client's database via an ODBC connection.

The website/server will have a MySQL database that will contain 2 tables with approximately 10-20 columns each, and should be able to support 2 more tables for each new client database version in the future. The information from these tables must be converted into a specific table format, which will depend on the client's database table version on the local machine. This version will be found by the client component querying a file, then asking the server for the data from the correct 2 tables for that version. The client's database will then be updated using sql INSERT statements if not existing, or UPDATE if the entry already exists.

There should also be a method where the client component, before updating the database, will send the information from these 2 tables up to the server and save them into a SQL file under the user's own folder with datetime stamp.

Taidot: AJAX, Java, verkkosivujen suunnittelu, XML

Näytä lisää: web update tool, web page format, web format, format web, remotely update website, table reporting mysql database web based java, remote java update, java database updater, create web based website updater, website tables database updates, web base database table update, update remote web, update database via web, web based updater, update database loacl remote, secure data base remote web site, mysql database entry tool, web based database client java, update web database, best web based databases, update database remotely, net web site, sugarcrm remote job, i do not exist, Web java

Tietoa työnantajasta:
( 8 arvostelua ) Kaneohe, United States

Projektin tunnus: #416343