This project is a data conversion from excel into SQL server via SQL scripts. The process of importing should be repeatable so that a user can import the attached excel file into a new table, run SQL conversion scripts and proper existing tables will be populated.
The winner of this project will be able to:
1 - Review, learn and understand provided Route Manager DB field definitions, diagrams and field mappings with screenshots material provided.
2 - Restore empty db and sample db .bak files to their own SQL server. Sample test db is provided to see how data is inserted into various tables.
3 - Import CUST data spreadsheet into a SQL tmp table
4 - Write SQL scripts to correctly move data from excel into various SQL tables in the Empty db.
5 - For this conversion customer data needs to be mapped into CUST SQL table and related tables (UDEF and DBINI).
45 freelancer đang chào giá trung bình $170 cho công việc này
Hi Sir/Madam. I will create a program for you to do this. Ready to start. Thanks. *** I will pay 15% penalty if the project is not completed on time ***
Hello, I'm interested in your project. Would like to help. What MS SQL Server version do you use? Will excel file be located on the server? Best regards, Elena
Hi, you can find my skills and references on linkedin (angnut) I have a lot of experiences in SQL and data manipulation activities. Please send me more details to have a feedback.
i am sql dba and having more then 5 yrs of experience , I am sql expert certified by oracle corporation and having good skill task related to import and export using any file. I can do this task easily