Consolidation of DBs
$250-750 USD
Paid on delivery
I am looking to consolidate entries in 4dbs. One has 1MM entries, one has ~250K, one has ~100K and one has 2000. All the dbs are in Excel, but I am not bound to that. I will accept final consolidation in MySQL or MSSQL as well.
The two challenges with this project are:
1. The number of entries. Excel has proven to not be useful to me due to the 1MM+ entries. If someone can work in Excel with such large number of entries, then great, otherwise SQL is fine.
2. One of the fields has information that needs to be unconcatenated (i.e. split into various other fields.). I am willing to work with the successful freelancer to offer suggestions and guidance as to how that can be done.
A cross-walk between the fields in the 4 dbs has already been prepared so the freelancer will know what fields need to go where in the results table.
Only experienced database and data managers need apply.
There is no milestone payment - payment upon completion only.
Project ID: #5798266
About the project
Awarded to:
Hi, I can help you in migrating the Excel sheets to MySQL. Using a database will be beneficial in long term and is very scalable. I can also help you in creating SQL queries for various day-to-day operations. P More
4 freelancers are bidding on average $333 for this job
Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award
Hi, good day. I am interested in your project. I have plenty of experience in this type of projects (consolidating entries and working with literally millions of of them) and I think I can help you. I would like to More
