Consolidation of DBs

Completado Publicado Apr 12, 2014 Pagado a la entrega
Completado Pagado a la entrega

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.

Procesamiento de datos Administración de bases de datos Excel

Nº del proyecto: #5798266

Sobre el proyecto

4 propuestas Proyecto remoto Activo Apr 12, 2014

Adjudicado a:

sawangupta

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 Más

$555 USD en 10 días
(32 comentarios)
5.2

4 freelancers están ofertando un promedio de $333 por este trabajo

zExcel

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

$277 USD en 2 días
(253 comentarios)
7.6
workerkmvw

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 Más

$250 USD en 5 días
(1 comentario)
1.8
mobion

Hi, I'm interested in this job. I'm an experienced mysql database manager. I have successfully done many similar project of merging/splitting and deduplicating data upon given criteria. I will consolidate your excel Más

$250 USD en 2 días
(2 comentarios)
0.8