1 / 12

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

rhian
Télécharger la présentation

MySQL Data Transfer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Site 1 Site 5 Site 2 Site 6 Master Site Site 3 Site 7 Site 4 Site (n-1)

  3. All the sites will have the same database tables and fields All I need is the data in 2 tables SyS_INI Sys_Info

  4. 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

  5. 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

  6. 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) 1st Record will have ID 1 and PCID 1 2ndRecord will have ID 2 and PCID 2 3rdt Record will have ID 3 and PCID 3 4th Record will have ID 4 and PCID 4 Database 2 both tables sys_ini & sys_info 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) 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) 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)

  7. 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

  8. 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

  9. 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

  10. Destination database is in the server.ini

  11. 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

More Related