Automate data import from CSV to SQL Azure

  • Status Closed
  • Budget $250 - $750 AUD
  • Total Bids 18

Project Description

Hi

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.

Get free quotes for a project like this
Awarded to:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online