DATABASE COMPARISON

We need to have a JSP module that can compare two or more tables and update the primary table with new rows or differences. The fully functional program should let user to select a few table columns to be compared from different databases such as MySQL and SQL server 2000. The program must be able to determine which database/table to be compared and which to copy to which. Then, map the field from one database to another database and compare to find the differences. The program must be written in JSP/Java and must be able to integrate to any internet site. The program interface should be clear and easy to use. Documentation with flow chart and clear documentation explaining the source code is required. Platform: - Need to work on all Windows, - Apache Tomcat server, - IE 4 onwards, - JDK 1.2 or above and - Mysql and SQL Server 2000 as the back end ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform - Need to work on all Windows, - Apache Tomcat server, - IE 4 onwards, - JDK 1.2 or above and - Mysql as the back end