Automate data import from CSV to SQL Azure

Hi, I'm very interested helping you importing data to your SQL Azure database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details about your database, so we can start asap. This my Skype id so we can discuss about it : ELBOUKHARIMU. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards

Dir Sir, I can build a ETL process to automate process your csv data and import to SQL Azule. I was working for an online advertising and we have many log files and we use Pentaho kettle DI to aggreagate data and make the reporting data. Also, i worked on SQL Azure on some projects at my company. I can show you my ETL process on my computer. Thank you. Thanh Truong

Hello, We already have a working application which synchronizes data (QA sample test results) sent to us via email. We can modify this application for your needs. I sincerely hope your decision will be to entrust us with the execution of your projects and looking forward to working with you. Please feel free to contact me for any clarifications. I look forward to speaking with you about this exciting opportunity. Sincerely, Raja Annadurai

Hi, I have experience working with SQL Azure that's why I'm sure you'll be impressed with my work. The program can receive file via email (or FTP) and upload data into SQL Azure like you want. Thanks. Roman

Hi!, I 'm SQL Serverexpert and I can help you to develop and implement the solution that you need. I have experience in import and export tasks to SQL Server. 10 years of experience SQL Server, TSQL, SSIS, SSRS. Thanks in advance!

I have extensive experience with MS SQL Server, Azure, data loads, and automation. I have worked with many other database vendors too. All told, I have 18 years of experience in migrating data between systems, and automating that process. The one major unknown in automating what you have described is how you receive the files from your partner. You mention email as an option, so I will base my option below on email. I am a technical consultant, so if you decide to work with me, I can investigate other options for automating the transfer of data. I would create a C# service that runs on a computer. This computer does not need to be a server, it can be any plain old computer. That service would monitor an email account. When an email arrived, it would save the attachments to the local computer. The service would then massage the documents as needed to match your Azure structure. Next, the service would load the information to your Azure instance. I am assuming that there is sufficient information in the tables provided to determine if an update or insert is required. Of course, the service would email status. I am all about automation. I hate having to do the same work over and over again, when it could be done automatically. I would be happy to help you out with this problem. As I said earlier, there are many possible solutions to what you have described, I have just picked one. Carl.

Hi, Having excellent work exp in development and maintaining of database. I can write sql queries and an utility which will import the data in your Azur server from csv files. You can check my feedbacks for similar project. Thanks

Hi, I am a DB developer with PHP experience. I propose to this job. I will be doing it in PHP I am not sure about your volumes in each of the tables. Generally loading is done record by record which is likely to be slow. I can provide the script to have bulk load facility (PS for a few 100 or thousand records this may not make much difference in speed.) Also some kind of automation logic (like downloading csv data from some server) can be built into the script (based on your requirements). I will be charging $250 for this activity Delivery will be in 5 days. Payment plan can be mutually agreed upon You have any queries, Please let me know,. Regards Sankar

I can get it done for you. I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, WordPress, SharePoint, VBA, C, C++ and Vb 6 Scripting Languages jquery and javascript, Third party tools like Telerik, Infragistics and Reporting tools (Crystal Reports, Sql Reporting Services and Oracle Developer). Looking forward to your feedback. Regards, Muhammad Ali Safder

There are 5 files (Bookings, Passengers, Sales, Payments, Agents) which all match up to 5 tables of the same name. I Can restructure you CSV files to be imported directly to your SQL Azure, with stored procedures. I'm expert in SQL server, familiar with CSV files. I Can do this for you.

It is better to use Windows Azura Cloud Service application I will develop for you. This Cloud Service will be a Worker Role Application which is similar to Windows Service on common Windows OS platform. So, the Worker Role will do the email download, extract the CSV and then do import to your SQL databases as well. So, basically you just need to email the csv files to specific address and let the Worker Role application do the download and complete the rest. let me know if this method is better for you

Dear davidcumming, I am very pleased to provide you an innovative solution for importing the data from CSV files into SQL Azure, I will create a PHP script to automate this process, of course you should have a PHP server, if you system doesn't have one then I can help in providing a step by step how to install one on your local system. Look forward to working with you soon. Best Regards, Rose Office

To I work on your project I need full access to the Azure server, the structure of the tables on Azure server, the data structure on the local server and the structure of .CSV data. Rregards.

I have 10+ years of experience working as Database Administrator/ Architect experiencing in Project Designing, Management& Implementation. Various solutions will be available with different requirements. so will choose and present you the best available/possible solution as per your business requirements. After you get satisfied, it will be implemented.

Dear Sir, I can solve your problem. To solve it, i thinks i need write two service. service 1: get file csv service 2: read file csv service 1 got, insert it into database