Find Jobs
Hire Freelancers

Add XML Data from NIH Reporter to a MS SQL database.

$30-250 USD

Κλειστή
Αναρτήθηκε περίπου 8 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
I need all the data from FY2000 from [login to view URL] to be put into a MS SQL data base and then saved as a database back up so I can restore the entire database. I also need the code that produced the data. I have a MS SQL query that I have written but it runs extremely slow. I've included two files, one that creates the data table and one of my XML code.
Ταυτότητα εργασίας: 10067187

Σχετικά με την εργασία

20 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
20 freelancers are bidding on average $180 USD for this job
Avatar Χρήστη
Hello, I am very much interested to provide you the solution so that you can get all the data into the database and the database is backedUp. If you want i can develop an application by c# which will download all the zip files from that link and unzip them all and import the data from each csv file to the database table. We can discuss more. Looking forward to have a positive response from you. Thanks
$180 USD σε 3 ημέρες
4,9 (60 αξιολογήσεις)
6,6
6,6
Avatar Χρήστη
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 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$111 USD σε 2 ημέρες
4,9 (30 αξιολογήσεις)
5,4
5,4
Avatar Χρήστη
Hello!!! i have build Bank Management System, Shopping/Order system,Patrol Management System. I have full experience in JSP, JQuery, PHP technologies. also , i have master laravel and codeigniter frameworks and anglar js, node js templates. keep in touch. my dear.
$315 USD σε 3 ημέρες
5,0 (5 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hi! I can help you with your project. WE can take that work you've done so far and use as a base. Please let me know if interested. Best regards. Eliot
$200 USD σε 10 ημέρες
4,7 (15 αξιολογήσεις)
5,6
5,6
Avatar Χρήστη
I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.
$120 USD σε 2 ημέρες
4,8 (17 αξιολογήσεις)
4,9
4,9
Avatar Χρήστη
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$247 USD σε 10 ημέρες
4,7 (9 αξιολογήσεις)
4,7
4,7
Avatar Χρήστη
Hey, you seem to be good with TSQL. I don't want to get into rewriting stuff just for the sake of it - instead of $250 for some custom baked solution, how about I just fix up your query to make it run 10 times faster for $100. That should be sufficient to get you going. The whole job would be similar to my most recent review (Build SSIS job to control existing XML -> SQL import procedure) - but I'm most interested in just the XML slicing part which I optimised very well for 17MB files. If you really need me to do the whole shebang, I can also. Just let me know. *** edit *** I must be confused - why do you want the backup/restore bit? That threw me off. Do you mean for me to do it here, back it up, and send you the backup. And also to give you my steps/scripts? Too much work - you only need an optimised SQL XML query.
$100 USD σε 2 ημέρες
5,0 (11 αξιολογήσεις)
4,5
4,5
Avatar Χρήστη
Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **
$155 USD σε 3 ημέρες
5,0 (10 αξιολογήσεις)
3,9
3,9
Avatar Χρήστη
Hello, Im interested to work on this. I have gone through the attached files and the website. I believe you want to backup of the sql database and the code, I would like to understand the code that you are expecting in SQL queries or any other language(C#, or VB - LINQ to XML). Initial find of the work is 83500 rows in the xml. Im happy to do either ways. Thanks for message me. Regards, Sheik
$150 USD σε 4 ημέρες
5,0 (5 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
I am Software developer already worked with MSSQL and XML I can store all XML contents using PHP to MSSQL table quickly
$116 USD σε 2 ημέρες
5,0 (5 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
I am an experienced SQL Data Warehouse developer with experience in MS SQL Server. My previous work has included deliveries for multiple FTSE100 and SME. My initial question is whether you want a sole MS SQL T-Sql based solution? If you do then it will be slow as your script has it correct, where it has to do multiple conversions on your text file. If you have a full version of SQL Server I would suggest using an SSIS package to do the upload job and failing that I would suggest using an intermediate engine - perhaps Excel to do the translating of the XML file with VBA to push the data into the SQL tables using ADO. Depending on what you do with the data there is opportunities to key the data to reduce the storage load through the intermediate load process technique which would make queries more efficient. I think there are good opportunities here and you need to decide how to leverage your existing MS infrastructure to do the best job. Open to discuss it. /R.
$200 USD σε 3 ημέρες
5,0 (1 αξιολόγηση)
3,4
3,4
Avatar Χρήστη
Well, I think we need to sit together for this solution. You have attached only a single file. Please share another. Kindly get in touch. Regards Priyam
$155 USD σε 3 ημέρες
4,9 (2 αξιολογήσεις)
2,3
2,3
Avatar Χρήστη
A proposal has not yet been provided
$166 USD σε 1 ημέρα
5,0 (1 αξιολόγηση)
2,1
2,1
Avatar Χρήστη
I can do this. ################################################################################################################################
$155 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$333 USD σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi! Just for confirmation, the proposal is copy all data since FY 1985 is it correct? can I use the CSV file or just the XML? I can do it faster Thanks Dayan
$110 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Charleston, United States
5,0
91
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Οκτ 6, 2011

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.