In Progress

Automate data import from CSV to SQL Azure

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.

Skills: Database Administration, SQL

See more: import csv sql azure, csv import sql azure, can automate file upload sql, sql azure csv import, to find a solution, sales administration, matching logic, import administration, find 100 sales agents, where to find sales agents, Sql Database administration, how to find sales agents, find sales agents, email administration, data mapping, c# azure, azure, azure database, automate], automate email, sql created, update sql file, import data csv sql server, csv import sql server, csv update

About the Employer:
( 5 reviews ) Cairns, Australia

Project ID: #5076953

Awarded to:

elboukharimu

Hi, I'm very interested helping you importing data to your SQL Azure database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, th More

$526 AUD in 10 days
(30 Reviews)
5.3

18 freelancers are bidding on average $511 for this job

truongngocthanh

Dir Sir, I can build a ETL process to automate process your csv data and import to SQL Azule. I was working for an online advertising and we have many log files and we use Pentaho kettle DI to aggreagate data and mak More

$611 AUD in 10 days
(31 Reviews)
5.3
rajaaind

Hello, We already have a working application which synchronizes data (QA sample test results) sent to us via email. We can modify this application for your needs. I sincerely hope your decision will be to entrust More

$750 AUD in 14 days
(5 Reviews)
3.9
gangabass

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

$309 AUD in 3 days
(10 Reviews)
3.6
vhrios

Hi!, I 'm SQL Serverexpert and I can help you to develop and implement the solution that you need. I have experience in import and export tasks to SQL Server. 10 years of experience SQL Server, TSQL, SSIS, SSRS. Thanks More

$555 AUD in 7 days
(3 Reviews)
3.5
carlheller

I have extensive experience with MS SQL Server, Azure, data loads, and automation. I have worked with many other database vendors too. All told, I have 18 years of experience in migrating data between systems, and au More

$750 AUD in 10 days
(2 Reviews)
3.2
chetanraj81lx

Hi, Having excellent work exp in development and maintaining of database. I can write sql queries and an utility which will import the data in your Azur server from csv files. You can check my feedbacks for similar pro More

$500 AUD in 3 days
(1 Review)
2.8
partsgr12

Hi, I am a DB developer with PHP experience. I propose to this job. I will be doing it in PHP I am not sure about your volumes in each of the tables. Generally loading is done record by record which is lik More

$250 AUD in 5 days
(2 Reviews)
2.6
AliSafder

I can get it done for you. I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, Word More

$250 AUD in 7 days
(3 Reviews)
1.9
clound7

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

$500 AUD in 5 days
(0 Reviews)
0.0
Singh160

I have 10+ years of experience working as Database Administrator/ Architect experiencing in Project Designing, Management& Implementation. Various solutions will be available with different requirements. so will choose More

$743 AUD in 10 days
(0 Reviews)
0.0
riki888vw

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.

$555 AUD in 10 days
(0 Reviews)
0.0
anewstarting

Hi.. First let me tell you I am a Java expert and no experience in Azure...You might be irritated and can just neglect my propsal... But please be assued that to develop a solutiion like this...all u need to know i More

$666 AUD in 7 days
(0 Reviews)
0.0
MohipuriTech

Hi, Just to introduce , My name is diktesh and I am a DB2 and SQL DBA since 9 years([url removed, login to view]) and just to give background I have worked with Lehman brothers(Investment bank) and Barclays capital in More

$340 AUD in 3 days
(0 Reviews)
0.0
RoseOffice

Dear davidcumming, I am very pleased to provide you an innovative solution for importing the data from CSV files into SQL Azure, I will create a PHP script to automate this process, of course you should have a PHP s More

$250 AUD in 14 days
(0 Reviews)
0.0
jasminery

It is better to use Windows Azura Cloud Service application I will develop for you. This Cloud Service will be a Worker Role Application which is similar to Windows Service on common Windows OS platform. So, the Worker More

$526 AUD in 3 days
(0 Reviews)
0.0
ahmedaziz86

There are 5 files (Bookings, Passengers, Sales, Payments, Agents) which all match up to 5 tables of the same name. I Can restructure you CSV files to be imported directly to your SQL Azure, with stored procedures. More

$555 AUD in 10 days
(0 Reviews)
0.0
caglarozenc

Database Administrator at [url removed, login to view] Blog : [url removed, login to view] linkedin : [url removed, login to view]

$555 AUD in 3 days
(0 Reviews)
0.0