Data Import into Microsoft SQL Server Database
€250-750 EUR
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.
Project ID: #10387758
About the project
58 freelancers are bidding on average €352 for this job
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
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
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 **
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
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
17 years of SQL Server experience. I can do this and at the same time optimise any queries that look immediately wrong. Regards.. Richard
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
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
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.
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
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.
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.
Hi, Can you please provide sample csv so we can check it? Looking forward to hear from you. Thanks
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
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