Data Import into Microsoft SQL Server Database

In Progress Posted 7 years ago Paid on delivery
In Progress Paid on delivery

Please offer your service only if you do speak english fluently. I am looking for offers within 250 - 350 €. If you do good work, I will add up to 200 € extra.

The data is provided in csv format. There are tools to import the data into a temporary table and a sql-server script that previously moved similar data from there to our productive tables. You will have to decide whether you want to alter the existing import scripts or if you want to create a new one.

Details:

The data is productdata (Names, Prices, Categories, etc.)

The item table contains parent and child records. These records must be generated from the imported data.

The child records reference to a product detail table. Product details have to be inserted there correctly.

Item numbers will have to be generated taking the existing number range into account.

An imageurl will have to be generated from the manufacturer's item id and inserted into the imagetable as well as a reference to the pictures in the main item table.

Your working environment will be a Microsoft SQL Server Management Studio accessed with TeamViewer. I will be present throughout the process and provide all information needed.

If you have any questions, please do not hesitate to ask.

Microsoft SQL Server SQL VB.NET XML

Project ID: #10387758

About the project

58 proposals Remote project Active 7 years ago

Awarded to:

andyzav

Hi! I'm a professional database and software developer with 10+ years of experience (.Net, MSSQL), including many completed projects with data export/import and processing. Speaking English very well. Your project is v More

€250 EUR in 3 days
(5 Reviews)
3.5

58 freelancers are bidding on average €352 for this job

sumon355

Hello, I am very much interested to do this work as i have the required skills for this work. As the import tool and sql script is already existed & used before, i will definitely like to use it. Looking forward to ha More

€280 EUR in 1 day
(339 Reviews)
7.9
riskypathak

I would love to do this kind of data migration job. I will prefer creating my own script but if previous script is easy to read and modify, then will use that. How about creating a small c# utility to do migration m More

€350 EUR in 1 day
(70 Reviews)
7.6
karunakartiwari

Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional having more than 8 years’ experience in Windows/Linux Server administration , Website Hosting migration, Mail server configurati More

€350 EUR in 10 days
(51 Reviews)
6.7
hwanghendra

Hi Sir/Madam. Please send sample csv. Thanks. Our slogan: ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

€298 EUR in 10 days
(122 Reviews)
6.3
sikandermandal

Dear Sir, This is Sikander. I have read you job specification and come across your requirements about this project. I have 14+ years of experience in software development and I am ready to start this job. Please dis More

€322 EUR in 5 days
(16 Reviews)
6.1
gkalish

Having 8 + years experience in SQL Server and willing to start the work immediately .

€388 EUR in 10 days
(99 Reviews)
6.4
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an More

€333 EUR in 10 days
(14 Reviews)
5.6
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie More

€300 EUR in 5 days
(41 Reviews)
5.9
weonlydo

17 years of SQL Server experience. I can do this and at the same time optimise any queries that look immediately wrong. Regards.. Richard

€263 EUR in 10 days
(39 Reviews)
5.6
kalpesh2804

Hello, I have 12 years of experience in C#, Vb.Net, MSSQL, MySQL, SQLite, Visual FoxPro 9. I can provide tool to import CSV data into MSSQL. please provide sample CSV file for analysis. Thanks Kalpesh

€300 EUR in 10 days
(22 Reviews)
5.2
IMExpertEngineer

Hi, can you send me ur csv file and db scehma. and i prefer to write new script from scratch. let me know if you want to discuss with me thanks

€555 EUR in 10 days
(9 Reviews)
4.8
phiona06

Hi! I've experience in MS SQL Server. I propose create the stored procedure, that can export your csv file in your tables. Waiting for chat with you for detail information.

€250 EUR in 6 days
(22 Reviews)
4.4
lurdsubas

Hello, I am developer with good experience in MS-SQL data migration and importation. From your description I may need to write an adhoc client app to help with generation/regeneration, but that would be decided when I More

€350 EUR in 2 days
(9 Reviews)
4.4
dat2na

Hello, I'm professional DBA with 8+ years experience. Working as DBA and DB developer in one of the leader company. I have experience of same jobs like SQL Server Administration and development by remotely. I'm top exp More

€333 EUR in 2 days
(4 Reviews)
4.4
Maheshpatel107

Hello, I am able to complete this task with 100% accuracy. I have 3.5 years experience in VB.NET, C#,VB6.0,VBA development. I have worked with VB.net as Front-end MS SQL Server as Back-end (.mdf) (.sdf) MS Acces More

€300 EUR in 7 days
(11 Reviews)
4.2
igorssv

Hello I can help you your project. I have in experience of working with MS SQL Server and various data processing. Also I can use my own MS SQL Server Instance Waiting for your response.

€300 EUR in 3 days
(5 Reviews)
4.2
ludiac

Hi, We have understood the task you want to be completed. We can send you questions over chat once you contact us. We have questions related to automated data import etc. Thanks.

€255 EUR in 7 days
(2 Reviews)
4.1
searcheverything

Hi, Can you please provide sample csv so we can check it? Looking forward to hear from you. Thanks

€263 EUR in 6 days
(9 Reviews)
4.3
shahzaib121

Hi Dear I have a lot of experience in Data Migration, DataBases +Data Warehous.I am DataBases + Warehouse certified from Sql Server . I have done many work in Requirments analysis , Data Staging, Data Warehouse, D More

€250 EUR in 10 days
(16 Reviews)
4.5
DeoTech

I am a database developer with 16 years experience in MS SQL. Can you provide a sample of txt file? Last of the same task 22 000 000 rows are inserting to MS SQL. I can create a C# WinForms or SSIS task. Regards

€555 EUR in 10 days
(16 Reviews)
4.6