Data importer. - open to bidding

$25-50 AUD / hour

Fermé

Publié

il y a plus de 8 ans

$25-50 AUD / hour

I have an SQL2008 database. The data needs to be imported into a SQLite database and cleaned up along the way. I need an importer which will read either the SQL 2008 directly or subsets of the data exported out as csv files. I can provide the complete database and explain in detail exactly what needs to be done. The import process will require some human decision making, the aim of the importer is to provide an efficient way to make this happen. I don't think it is overly complicated, reading the files, regular expressions to help filter and map which fields should be mapped to the fields in the new database. The project is for my company and the budget is reasonable. At a guess perhaps it is 40 hours work? Let me know if you are interested. I want to work with someone in Australia - as this is easier for language and timezone - as I am in Perth. I would like it to be written in Python as I have some experience in it and can learn something along the way.

Software Architecture

N° de projet : 8269428

Concernant le projet

16 propositions

Projet à distance

Actif à il y a 9 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

16 freelances proposent en moyenne $35 AUD/heure pour ce travail

@helmot

I have +10 years of experience in Python programming! You are right, best language to do such scripting task is Python. I am expert in transferring data between different types of databases. Take a look at this example project I did some months ago on freelancer: https://www.freelancer.com/projects/php/Product-Customer-Data-Import-Bigcommerce/ https://www.freelancer.com/projects/4965956.html In most of my python projects, I use SQLite as database so I have no problem with that. I will use ODBC driver to connect to your MS SQL Server. There is one unclear thing in your description of project. Does really human decision making needed or we can do all of that with re ? Can you provide more details please? Thanks, Helmot

$30 AUD en 40 jours

4,8

(136 commentaires)

7,7

@prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.

$25 AUD en 1 jour

4,8

(40 commentaires)

6,4

@anuyadav1

i can make it in python , and timezone will not be an issue .

$40 AUD en 40 jours

4,8

(67 commentaires)

6,0

@cgullapalli

HI, i have team of professionals of SQL. Looking forward to work on this project. Please see my testimonials.

$40 AUD en 1 jour

5,0

(7 commentaires)

2,3

@vw98358vw

Well, I have the native English speaking portion you are looking, but I am in the States. I work all sorts of strange hours here, which should translate fairly well for you in the end. The number of hours required may be substantially less, but I left it a little high due to the different data types available in MSSQL versus SQLite. You also didn't mention the amount of data, but I have quite a lot of experience with ETL and making the conversion shouldn't present any problems. PHP is actually my strongest language, but Python can certainly be used. Looking forward to hearing from you. Jesse

$55 AUD en 30 jours

5,0

(1 commentaire)

1,8

@impuneetg123

I am python expert and it's a simple script job for me. I can teach along the way too so that you will no longer be dependent next time.

$33 AUD en 1 jour

0,0

(0 commentaires)

0,0

@sel205

Hi, I know that you are looking for Python programmer. Just curious, maybe you want to consider a Windows application instead, using C#.net. Let me know if you are okay with it. So the program will 1a. Read from SQL 2008 table, plus 1 search text box 1b. or Read from csv file and show all data 2. List all the available columns from the source and allow user to map. I am planning to use 1 ComboBox for each input columns. The combo box will list down all the columns in destination table 3. Map it and insert to the SQLite database

$30 AUD en 8 jours

0,0

(0 commentaires)

0,0

@sureshdewenda

I believe that the skills for which you are looking for, i am best fit. I have approx 2 year experience in python and machine learning. I have done many projects related to regex.

$25 AUD en 40 jours

0,0

(0 commentaires)

0,0

@pashrel

I'm a programmer. I believe the experience you'll find in my profile will be ample to accomplish this project. I'm available during Australia time if you like. I'm unclear about the hours needed. You wrote 40 hours and also wrote 1 hour/week. I'm flexible with regards to the hours. If I understood right you're migrating SQL 2008 data to SQLite. Do you have both servers up at the same time? Also, do you have a platform for the Python development? Upon accepting the project please respond to the above and let me know what the best method of communication for you: phone or skype. I look forward to working with you.

$41 AUD en 1 jour