Annulé

Script to convert MS SQL data into mysql data for injection

For a project I'm working on I need help to write a script that will be run by a cronjob every night on a FreeBSD server.

The script needs to:

1. Fetch/download/ftp (or preferably securely fetch) and MS SQL dump file from an external source

2. Parse it and convert it into an SQL file for mysql that we can inject via a cronjob into mysql 5 server and a Joomla Sobipro ([url removed, login to view]) database/tables.

The MS SQL data comes from a customer registry system. Typical we need 15 elements to be moved. Ie; Company name, Address, Telephone, a few text strings, state, contact person and so on.

In the mysql sql file you will have to add some static values for cells and also some counters.

The script needs to be written in a language that can be run by command line on FreeBSD. Ie. shell script, perl or even PHP.

I think there are about 3000 companies in the MS SQL database today.

This should be a rather simple task for someone who has experience with SQL and scripting.

I need to know how many working hours you estimate to spend on this project when bidding! Thanks.

Compétences : Perl, PHP, Script Shell, Architecture Logicielle, SQL

en voir plus : convert sql script mysql script, server scripting language, run shell script from php, need sql help, ms companies, how to write on line, convert sql script mysql, convert sql data joomla, sql experience, perl scripting language, ms project help, shell script or, need someone help to write a project, how to write task 1, write some sql for a project, write a simple php script, today data, telephone script, sql injection, sql data

Concernant l'employeur :
( 0 commentaires ) Kristiansand S., Norway

Nº du projet : #1211221

14 freelance font une offre moyenne de $854 pour ce travail

Mindon

check the PMB please.thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(91 Commentaires)
6.4
gangabass

I can do this for you. See PM for details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(210 Commentaires)
6.3
stevearm

Hello, bid details in your PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
5.6
claudiu07

Hi, I have extensive experience with web applications in PHP and databases, including MS SQL and MySQL. I'll be happy to help you. Cheers

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)
5.4
marasinghe82

hi, I’m very much familiar with SSIS we can do the all scripting on your MS SQl databse. we can shedule it on SQL server job and it will give all the messeges about completing of jobs. please assign your job t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(26 Commentaires)
4.4
alexstech

Hi, I have good experience in MSSQL, MySQL and PERL. I can do a script for you in perl which will be compatible with FreeBSD. Send me the MSSQL dump I will start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)
3.0
devexperts

We have some excellent ideas in this field that you would like to know. May be you do not need to write scripts with our idea of syncing tables across various databases. The best part is our solution works both ways. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
4.4
spykecoders

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello There, I look forward to talking to you further and getting Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(6 Commentaires)
3.2
srinivasanrajan

Please check your P.Messages.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)
0.0
MAAALMEIDA

- PHD in Bioinformatics - Seven years of experience: -Perl programing -SQL database administration -UNIX Shell Scripts - Daily feedbacks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)
0.0
nojnish

please refer PMB for details regards Babu

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
svenkateshwar

I have worked on data migrations on to mysql from oracle for such smaller tables using perl and shell script. It shouldnt take more than 3 days to complete keeping a day as buffer. Can you send me one line of the sql Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
blaiddgwael

I've experience with python, php and antlr.(building parsers and compilers)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
kostasbre

I am an expert Perl programmer. I have complete similar tasks in the past between Oracle and mySQL.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
mostafabahaloo

hi please check you inbx

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0