Find Jobs
Hire Freelancers

Database Into SQL Format 220 million records

$250-750 USD

Terminado
Publicado hace más de 7 años

$250-750 USD

Pagado a la entrega
Have 220 million records database in text format with delimiters. During SQL import keep coming up with come errors becuase all the fields are not lined up perfect or over lap. Those few records can be omitted. Need the database reformatted from text into sql with all the columns perfect. Has 364 columns per record. Need a single file in sql format, as “[login to view URL]” Should be over 220 millions records imported
ID del proyecto: 11825958

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello,\r\n\r\nI would be happy to work with you to import your data into SQL server and provide you with a backup of the new table (.bak) that can be restored to your system.\r\n\r\nIf you have any questions please do get back to me.\r\n\r\nDamian
$50 USD en 10 días
5,0 (8 comentarios)
5,0
5,0
38 freelancers están ofertando un promedio de $496 USD por este trabajo
Avatar del usuario
Hello Sir, I am an expert SQL developer and I can help you with this. I will need a sample of the file and I'll create an .net exe which will read data from your large file and create the sql out for you. In this case you won't have to share the file with me as well. Thx Aanvik
$250 USD en 3 días
5,0 (43 comentarios)
6,6
6,6
Avatar del usuario
Hi, can you provide me more info about this project? 1) Which db are you using? MySql, SQL Sevrer, Postgres, Oracle... 2) I don't this is possible to put 220 milions of records in the same sql file as insert scripts, you need to split them in several files. 3) Which errors do you see, your phrase "... come errors becuase all the fields are not lined up perfect or over lap ..." it is not clear. Ragards Armando
$1.578 USD en 10 días
5,0 (13 comentarios)
6,8
6,8
Avatar del usuario
Hi, i am ready for this, please send me the records you have. .
$250 USD en 1 día
5,0 (17 comentarios)
5,1
5,1
Avatar del usuario
Few questions first: 1) what is size of data file now? 2) which database and which version you are using for this? 3) do you have any server to process files before loading into database? can you please give me sample records first? I am Teradata/ETL expert, having experience of managing and loading terabytes of data. You can check my past reviews(all 5 stars)
$250 USD en 10 días
5,0 (8 comentarios)
4,9
4,9
Avatar del usuario
$611 USD en 10 días
5,0 (3 comentarios)
4,8
4,8
Avatar del usuario
Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer
$555 USD en 2 días
5,0 (3 comentarios)
4,4
4,4
Avatar del usuario
Hi! I'm senior lecturer on databases with 10+ years experirnce in different DBMS (MySQL, PostgreSQL, MS SQL Server, Oracle). Please chat me with detail task. I need know what DBMS you use. And table columns options (create table instructions). Send me txt file then I estimate how much time I'll doing reformatting.
$333 USD en 5 días
5,0 (21 comentarios)
4,5
4,5
Avatar del usuario
Hello, Im reliable freelancer to work on this, I will take max 7 days but i will deliver before itself. I would like to know the destination table details to confirm. I will develop a simple tool to insert the records into table. You can handle the exceptions based on the data conditions. Thats the immediate idea/plan. Thanks for your reply. Regards, Sheik
$250 USD en 7 días
4,8 (12 comentarios)
3,8
3,8
Avatar del usuario
I can do it ising SSIS /.dtsx Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 2+ years of experience in vb 6.0 Application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain • 3 projects experience webscraping • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
$350 USD en 5 días
4,9 (6 comentarios)
3,7
3,7
Avatar del usuario
Hi. I am a professional SQL developer with a computer science degree, a software engineer post-degree and completing a MBA in project management. What db management will you be using to import? SQL Server? PHPMyAdmin? Also, do you have a budget? I am online right now. Thanks in advance. (This is not an auto-message)
$555 USD en 0 día
5,0 (6 comentarios)
3,4
3,4
Avatar del usuario
Hi I have 3+ experience in web development. I did many job like this. I have strong knowledge of Mysql, Oracle, Database Design and I have also strong knowledge in languages like Java, JSP, PHP, Javascript, Bootstrap CSS, Ajgular JS, HTML, CSS, JQuery etc .
$500 USD en 10 días
4,8 (6 comentarios)
3,6
3,6
Avatar del usuario
Hi sir I am Hasan Jack and I expert database developer. I am sure I can help you with your task with quality and perfection. Looking forward to hear from you. Regards, Hasan Jack
$500 USD en 10 días
4,5 (8 comentarios)
3,9
3,9
Avatar del usuario
Hi, I have done this kind of task before, I can do it for you within 5 days. Kindly inbox me for more details. Thank you
$444 USD en 5 días
5,0 (3 comentarios)
2,9
2,9
Avatar del usuario
I can help you with your task. Please discuss in detail.
$277 USD en 5 días
4,7 (5 comentarios)
3,0
3,0
Avatar del usuario
hi, i can help you with your project. send me more information about (like sql version) via freelancer.com chat. regards
$744 USD en 5 días
4,9 (3 comentarios)
2,5
2,5
Avatar del usuario
I have more than 3 years of an Experience in SQL Server Database Administration. My Skills are as follow : Configuration of AlwaysOn, Clustering, Performance Tuning , Query Tuning, Writing Complex T-SQL Statements, Writing Stored Procedures, Database Design, Performance Monitoring by Wait Stats, Performance Monitor, and Activity Monitor, Database Mirroring, Replication, Log Shipping,SSIS,SSRS You can message me here for any other information. Thanks
$555 USD en 10 días
5,0 (2 comentarios)
2,6
2,6
Avatar del usuario
We are a group of very sound developers and designers. We are committed to give a quality work with satisfaction to our Clients. We are expertise in: - .Net - C# - Cloud Hosting - Azure - Angular JS - MVC - Selenium - eCommerce - SQL Server - JavaScript - JQuery - CMS Our Services: - WEB DESIGNING - WEB DEVELOPMENT - CMS DEVELOPMENT - DATA ENTRY We are expert on selling Online products on below market place - - eBay - Amazon We believe in delivering 100% quality and satisfactory results to our clients.
$250 USD en 2 días
5,0 (1 comentario)
1,9
1,9
Avatar del usuario
Dear Sir, I think i can help yo with this project. I can create an application for test to sql. So you can use it later too. payments only after work 100% done
$250 USD en 3 días
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
I would like to work in this project, I have experience in data upload and I can help you.
$277 USD en 5 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Hello Sir I am expert database administrator , have experience in Oracle , MySQL , PostgreSQL databases for more than 4 years , I worked in many Telecom Operators in the Middle East and , and I wish you give me this opportunity and I will do the best quality with the lowest price
$250 USD en 10 días
5,0 (2 comentarios)
0,8
0,8

Sobre este cliente

Bandera de PANAMA
Las Vegas, Panama
5,0
42
Forma de pago verificada
Miembro desde jun 5, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.