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.
18 freelancers are bidding on average $511 for this job
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
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
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.