Closed

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
Employer working
Awarded to:
Skills Required
Project 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.

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