Automate data import from CSV to SQL Azure
This project was awarded to elboukharimu for $526 AUD.Get free quotes for a project like this
Project Budget$250 - $750 AUD
Please only apply if you have experience in migrating data and SQL Azure.
We have a SQL Azure server, and our partner has created some CSV files closely matching a few of our database tables.
I want to find a solution where we can receive the files every day and upload them into our SQL Azure.
The files closely map to our database tables, and I will provide a mapping to be 100% clear.
There are 5 files (Bookings, Passengers, Sales, Payments, Agents) which all match up to 5 tables of the same name.
Each file has a unique identifier from the main system, which we store in our system.
The logic will be to add or update the data from the CSV to the system.
We will discuss how we automate the files. This will preferably be via email, or it might be that we have to upload them to Azure some how.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online