Work with a 120GB SQL file

Hello, As an expert in SQL and having sound knowledge in importing BIG data, i am very much interested to do this project. I can do any of the options you mentioned. I have other options also if you like. May be importing the data into a RDBMS and showing the data in the web/windows application would be better. I can find the best option once i see the data. Can you send me a part of the file or the whole file? Looking forward to have a positive response from you. Thanks

Hello, I am a veteran (25+ years) database developer with real industry experience using SQL Server, MySQL, Oracle and a few others. I have serious SQL and database skills. Managing multiple CSV files would be a nightmare - instead, I would propose a local (on your laptop) a MySQL database (free), load this 120 GB (this is not small but medium size) into database and either build a custom front end or use the out-of-the-box MySQL front-end - my guess is that the out-of-the-box front-end should be good enough. I will teach you some basic SQL - if that proves difficult, then I will build a simple UI. I look forward to hearing from you. Best Regards Kashi

Hi, I think (2) Extracting the data to multiple (much smaller) CSV files and sending them back to you.) will be better .I can build small app in Visual Basic for that task . I have many ideas and suggestions for your project . Some other details required . You can discuss with me.

Hello, how many tables are there in the sql file ? I can do option #2 Kindly send me a message to discuss. Thanks & Regards, Everest Technology

Dear Employer, I have read the project details and confident to work on your project. I have extensive knowledge on SQL, MySQL, database development,etc . Kindly message me so that we can discuss more about the work. Regards Lucky

I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems.  I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management. I am looking for long term stable remote work and good client with not only work but good values also. I can work in any time zone and join immediately. You can check my profile.

Hi,I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker

HI cool mate. THat's clear about your two problem Please send me message to discuss more detail via chat Thanks Denis

Dear Sir; We have gone through your project placement and it matches our expertise. We understand you are looking for an expert Database Administrator who is efficient in ETL (Extract, transform and Load) data from flat to MySQL Database and apply the search on top of it. Well, we have experienced MySQL/MariaDB Database Administrator. we have almost 12+ years of experience as core Production Apps DBA; solely responsible for Administering, developing, Managing, Designing, Planning and Installing MariaDB and MySQL Server Enterprise databases with High/Maximum availability configurations. We have a team of MySQL DB administrators We are confident, energetic, and enthusiastic IT professionals with potential for career building. working on different state-of-the-art technologies with leading companies. Our specialization and experience encompasses design, development, and administer very large/complex online transaction processing databases. Yours Truly, Exp - 12 year Skillset - MySQL 5.6/5.7/8.0, Group replication, MySQL Cluster, Oracle Cloud/AWS, Oracle 8i/9i/10g/11g/12c, RAC, Data Guard, Goldengate, Oem, Oracle Exadata, Oracle SuperCluster Oracle Weblogic 11g/12c, Oracle Ohs 10g/11g/12c, Oracle EBS 12.1, OBIA, Joomla, Cassandra, Postgresql 9/12/11, MS SQLServer 2008 - 2016, MS Access, Azure, Oracle Cloud Infrastructure IIS, AWS, LAMP/WAMP, Storage, Hardware And Unix Operating System. Regards!

Hi, Hope all are fine. Thanks for uploading this work opportunity. I am happy and honor to bid this project. Kindly give a chance to work for this project as I have 10 years of reach experience in various databases including SQL, My SQL, Database Development . I will wait for your kind response along with requirement. Thank you very much

In fact, it depends on data in that sql file and on a person, who will work with it and their targets. So provide these details and we will discuss. Best regards.

Hello How are you? I hope you are going well. I am very good at SQL, SQLlog and then PHP. so I am good suitable for this job and then I look forward to hear from you soon. Thank you.

I have read your project description in detail and it seems just like that you posted this for me. I have 10 years of IT programming. My Technical background Database/Datawarehouse - SQL Server, Oracle, MySQL, PostgresSQL BI - Microsoft MSBI and Informatica ETL Dotnet - C#, VB.NET, C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) Statistical: SAS, SAP BI, Oracle BI, MS SQL Server BI suite and SPSS Server Microsoft Windows Server 2003 to 2016 and Unix/Linux. Having fully considerate, I feel confident to fulfill your requirement with High quality. First of all, I think we should discuss more via chatting. A Chance of cooperation between us can let me make you satisfy with my result. Only perfection must be delivered. Thanks...

Hi I understand what you what with this project. First choice seems to be reasonable for your usage. I could build site for you. Ping me to discuss more. Thank you. s.b

Hello I fully understand your requirement. I can make search web pages according to your need. Also can convert smaller fraction into excel or csv format. I have done this kind of work previously. Let me do this job for a smaller portion then you decide further. We can discuss in chat.

Hi I have experience working with large SQL files and could help you manage your database. Thank you for your time and attention. Looking forward to hearing from you. Regards

I suggest to write a simple script / program to extract your file into smaller one. I have many experiences on this kind of data when working with trading data at the Option Exchange in US. Contact me if you want this solution. Be my first client ^_^.

Hi Sir, I have lot of experience in building web sites using ASP.Net that retrieve data from SQL database. Your option is good. We can implement the solution like below: 1. we can build a small website with search page by including required fields 2. Retrieve the data based on the search and we can display in a results web page 3. we can put "Extract CSV" or "Extract Excel" (its your choice whether you want in CSV or Excel) to extract the results into either CSV or Excel file. I would like to know more details. Please send me message so that we can discuss on the requirement. Regards, Rajitha

Hello! I can provide you full support for this project. I have high experience with web technologies and I am pretty sure I can help you. So, let's start!

What kind of infor do you have stored in this sql file? is all in the same table or do you have multiple table to the representation. I can build a simple webpage to see the info, search, manipulate, etc and I can add a export button to generate a excel, cvs... file, but be in mind that you have 120 GB of info, and this is lots of information, depending on how it is stored it can be slower or faster If not, I can do a script to export directly all info in database. Both things can be done. Let me know your thoughts