Transcript MySQL Data Transfer

MySQL Data Transfer
Looking for an application that do the following
Programming Language: Delphi 7 or Delphi 2006
DO NOT USE ANY Components
• Transfer the content of 2 Tables from Multiple number of
Databases The list of Databases will be in a table
• Create a transfer schedule Daily or weekly or monthly
• Create Transfer log
• Create Error Log
• During the transfer I will need progress bar showing the
status of the transfer
Site 1
Site 5
Site 2
Site 6
Site 3
Master Site
Site 7
Site 4
Site (n-1)
All the sites will have the same database tables and fields
All I need is the data in 2 tables
SyS_INI
Sys_Info
When transferring the data from a database to the master database
PCID will need to be Reset (reassign)
As you can see the PCID has to match between sys_ini & sys_info in both tables
So when resetting the value of the PCID it has to match on both table for all the sites
With out duplication
Database 1
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
Database 2
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
Database (n-1)
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
Transferring
When Transferring the data from Database # to the master database
The PCID has to match between sys_ini and sys_info and can’t be duplicated
in the master database
Databases
Master Database
Database 1 both tables sys_ini & sys_info
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
Database 2 both tables sys_ini & sys_info
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
3rd t Record will have ID 3 and PCID 3
4th Record will have ID 4 and PCID 4
5th Record will have ID 5 and PCID 5
6th Record will have ID 6 and PCID 6
(N-1) Record will have ID (n-1) and PCID (n-1)
On both tables sys_ini & sys_info
Database (n-1) both tables sys_ini & sys_info
1st Record will have ID 1 and PCID 1
2ndRecord will have ID 2 and PCID 2
(N-1) Record will have ID (n-1) and PCID (n-1)
Results After Transfer
Master Database
All the Data from all the databases
With out duplicate of the PCID
Fist Transfer the master database will be empty
From Second Transfer on: make a copy of the both tables sys_ini and sys_info
Sys_ini_Date and sys_info_Date
I will need X days copy X= the number of copy: Get it from server.ini (See picture)
Then
Empty or overwrite the existing data with the new data
•Create a transfer schedule Daily or weekly or monthly
I need to have a scheduler tab when I can Schedule the transfer from a selected
Databases or all databases
I need to have a tab where it will have 3 buttons
1 – Transfer from all databases
2 – Transfer from selected databases
3 – Close minimize the Application to the tray
Databases information Table
Site Name
MySQL Database IP
MySQL Port
MySQL Database Name
MySQL Table Name
MySQL Database User Name
My SQL Database Password
Last Transfer
The application should have
A configuration file Server.ini
Where I can set the port. IP, User Name,
Password, Server Name
Destination database is in the server.ini
If you have any suggestion or better Idea do not hesitate to message me
If you have any question do not assume just message
Thanks a lot
Donnie