We are looking someone to develop small software application for transferring of the database records from/to Excel/MySQL.
Here is the case:
We have "Database1" with 200k records, with 5-6 fields in csv / excel format and we have "Database2" with 150k records with similar but not the same 6-7 fields".
We need software application for easy transfer of the records from Database1 to Database2 and reverse. There will be different tasks like (Examples):
- transfer records from Database1 to database2 , based on criteria - "do not exist the same record in Field2"
- transfer data from Database1 to Database2 in Field3, where Field2 match.
- modify Filed4 in the records of Database 2 where Field2 and Filed3 are the same.
14 freelancers are bidding on average $115 for this job
Hello! I had done a lot of the same tasks. Once I was working for a phone company and there was over million records to deal with. So I can be accurate with your data, build necessary queries and process them
I've done several projects like this and have experience with both MySql and Excel. I can write the transfer application in .NET C# (either desktop or web app)/