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.