Find Jobs
Hire Freelancers

Create SQL Dump from CSV

$250-750 USD

クローズ
投稿日: 9年近く前

$250-750 USD

完了時にお支払い
Hello, I have a large CSV file - standard format, which can be imported directly via PHPMyAdmin. However, the file is too large, and fails. Splitting the files into smaller sizes, works but is inefficient. I am looking for someone to convert this CSV into an SQL dump, which can be imported as .sql instead of .csv Thanks for your time,
プロジェクト ID: 7621684

プロジェクトについて

14個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
14 freelancers are bidding on average $337 USD for this job
ユーザーアバター
I'm a computer science professional with a PhD degree and extensive experience in SQL and Excel. Please see the reviews on my profile for ALL skills. It would be my pleasure to do your project. Please have a look at a large Excel project I did recently: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$275 USD 2日以内
5.0 (45 レビュー)
5.6
5.6
ユーザーアバター
Hello. How big is "large"? Please state the precise size of this CSV file and the number of lines it has (so I know how many records are there). Will this be a recurring thing or an only-once import? Do you have shell access in your host? I can take another approach which won't time out if I can get shell access. PHPMyAdmin import CSV file by issuing an insert command for each line on your CSV file, which is slow and inefficient. I've dealt with this problem before and there are several approachs that can be taken depending on the available tools. Besides the one you propose and the one I already mentioned, another one could be to convert the CSV file to a single-insert SQL command which will be the most efficient way to import your data. Please send me a _schema_ dump only of your DB, a sample row from your CSV file and tell me the answers to my first questions. Looking forward to working with you.
$555 USD 10日以内
5.0 (1 レビュー)
4.4
4.4
ユーザーアバター
Hi, I can create PHP script or Java program(console or GUI) to convert your csv to sql you can choose, if file is too large then is better java because can see how progress. If you have question you can contact me. Regards
$277 USD 1日以内
5.0 (1 レビュー)
2.2
2.2
ユーザーアバター
A proposal has not yet been provided
$526 USD 10日以内
5.0 (1 レビュー)
0.8
0.8
ユーザーアバター
Hi, will be glad to help you with this task. Quality of my work guarantee. Just give me the file and I will do my best to convert it to sql. Thanks, -Yui
$250 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I am pretty much used to handling big CSV files and SQL language. As for a conversion, it should be possible to do it by using my knoledge.
$250 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I assure you of a good and fast result, You won't be deceived so please hire me, you won't find better than me for this
$333 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Ill do it for 150 but cant bid lower than 250 which is min budget. In 1-2 hrs. With payment on completion
$250 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, PostgreSQL DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia, Canada, GB, USA and Russia. Currently I am working on a USA project Please see the review. Sir I have done lots of data migration and I am confidant that I can do this for you but need some time about 5 days minimum as I am tied up with some other work. Appreciate your kind attention in this regard, Warm regards,
$278 USD 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I can create a java program that will read from the csv file and convert the data into insert statements in an sql file. Please give me a sample file so that i can demonstrate this. I will be available during indian standard timings. If you are happy with it i could make you a jar file which you can use for converting any csv file into sql scripts. BID IS NEGOTIABLE
$250 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, I'm a database/software developer with more than 30 years of experience. The past 20 I worked (in-situ) on database development/implementation for two international organizations, including the United Nations. I'm sure I can help with your project. A MySQL dump is nothing else but a SQL script to generate the schema and add the data (INSERT) in your database. The .sql dump file can be easily generated by developing a small application that would inject the necessary commands to create (if necessary) the tables, and to insert the data (from the CSV file) in them. I could do this application in any language of your preference, including Delphi, VB/VB.NET, java, etc. The application could be used to import other data too! If you think you may be interested in my services, please open a private chat. I can provide a CV (for you to check references/experience) and we can further discuss the data you need to import into the database. Best regards, Marco García
$722 USD 8日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi. I am professional database developer. I have a lot of experience on similar database projects. Check my profile. If you like my offer, feel free to contact back and we can discuss more. Thanks
$250 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have a lot of experience with both file operations and databases, such as mySQL. Not only will I convert your file, but I can guide you through the process of importing the data into your database. If the file is very large, converting it into sql may not work (the import could still timeout or fail for another reason, such as reaching a memory limit). In that case, I can either try to adjust your server settings (if you have access) or write a script for you to take care of the import.
$250 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Have good knowledge and experience. Will be able to complete the job to your satisfaction. Please feel free to contact me to discuss.
$250 USD 2日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

CANADAのフラグ
Brantford, Canada
5.0
10
お支払い方法確認済み
メンバー登録日:6月 20, 2013

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。