Sports results database migration/merge

I am attaching a zip file containing two sql files. Both contain very similarly sized and similarly structured databases of sports results. I need to move all of the results from "[url removed, login to view]" into "[url removed, login to view]". There are several important things to note so I will list them one-by-one:

1. The lookup table "lifts" does not need to be migrated, it is basically the same in each db

2. The lookup table "weightclass" is very similar but there are slight differences. Three tables in "[url removed, login to view]" do not exist in the other db. You can create new rows/ids for them. I've attached a document to explain which weight class ids go with which and also which three need to be created in "[url removed, login to view]".

3. While the database structures are very similar, you will find some differences in the "lifters" table. When creating new lifters in the "[url removed, login to view]" database, please transfer "full_name" to "iwfname".

4. Most of the tables in the database to be migrated can simply be moved as in without any sort of merge or anything beyond creation of new ids and managing the changes of those ids in the tables (ie, if meets get a new id, that will need to be adjusted without disturbing the other meet with that id, etc). There are no overlaps in the meets, attempts or weights tables so there is no merging that needs to be done there.

5. The "lifters" table will require the most work on your end. The reason is that there is significant overlap between lifters in both dbs. I would like for you to apply the following rules. If a lifter has the same birthday (ignore January 1st birthdates), country and gender as a lifter in the other database, please present all of those to me on a screen in the migration script. I should then have the option to merge the results or to create a new id. Some helpful information should be shown to me by each name (ie, name, country, how much they've weighed, how much they've lifted) to help me decide if they are the same person or not. If a lifter does not meet the above conditions (birthdate, country & gender), simply create a new id for them and I will find other ways later on to try to find any duplicates that may have slipped through. Do not pay attention to name in the "matching" process as names are often presented differently -- birthdate, country and gender are much more reliable data points.

6. These two databases are just 2009 and 2010. My actual databases are much bigger. I'm just giving you 2009 and 2010 to make this more manageable. But, as I need to merge my bigger databases, the deliverables for this project are a script that works to merge my databases.

Please let me know if you have any additional questions. This is a relatively simple project as there is not any tricky logic. It will take a few minutes to code but I think it's straightforward.

"slight differences. Three tables in "wl-small"

should be

"slight differences. Three rows in "wl-small"

Skills: MySQL, PHP, Software Architecture

See more: sql get duplicates, simply reliable software, questions on data structures, my sql databases, my sql create database, matching logic, list in data structures, list data structures, how does merge sort work, data structures through c, data structures questions, data structures list, find duplicates sql, database creation software, wl, sql duplicates, new sports, merge data, data migration software, data merge, simple project data structures, structured database, merge results, big databases, merge sort code

About the Employer:
( 57 reviews ) Merion Station, United States

Project ID: #4665457

8 freelancers are bidding on average $221 for this job


I will leave my name here for your reference should you come to the conclusion that this is not as trivial as you make it to be and need a pro to complete. The script itself may be, but the handling of duplicates and More

$175 USD in 5 days
(40 Reviews)

Done Sir:) Gone through the details. Am confident to complete this job with proficiency. Ready to start now.

$180 USD in 5 days
(47 Reviews)

Hi, we are a team of programmers and designers with expertise and experience in PHP, Mysql, jQuery and Ajax. We have coded and designed websites for various types of businesses very successfully. We have developed many More

$144 USD in 3 days
(51 Reviews)

I am ready to start. Please check PM for details.

$88 USD in 3 days
(31 Reviews)

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$618 USD in 10 days
(5 Reviews)

PHP/MySQL experience, timely delivery. Please check PMB.

$129 USD in 4 days
(10 Reviews)

Hi, I can help You

$111 USD in 3 days
(4 Reviews)

Experienced with Databases

$170 USD in 3 days
(11 Reviews)

Hello, I can help.

$277 USD in 10 days
(5 Reviews)

Hi i can do it, i have great experience with databases.

$105 USD in 2 days
(0 Reviews)