database replication program
Source from ODBC (Read only) copying certain data to MySQL. need an interface to configure what tables and fields are being copied. destination schema can match source but program will create and define tables and columns automatically based on defined configurations. program will scan source tables and determine any changes based on a modified date column and update, or insert if new. will be scheduled to run on a cycle. once complete the program will update a control table with success or failure and date time and duration and count of inserts and count of updates. A program that will synchronize two databases (source = ODBC [Pervasive – read only]; Destination = MySQL) with several tables and columns that are configurable. Requirements: 1. Replicate altered data from the source data set to the destination, including source row deletions. 2. Must allow for configuration of database sync details such as tables, and columns in each table, are to be synced (i.e. not complete database
About Me
Lecturer on the DataBase; Data Mining; Parallel Computing; Designing Compilers; GIS technology; Network Information Technology.
