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.

Skills: Perl, PHP, Shell Script, Software Architecture, SQL

See more: 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, sql and c, sobipro, shell script, MS sql, inject

About the Employer:
( 0 reviews ) Kristiansand S., Norway

Project ID: #1211221

14 freelancers are bidding on average $854 for this job


check the PMB please.thanks.

$500 USD in 5 days
(91 Reviews)

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

$250 USD in 2 days
(210 Reviews)

Hello, bid details in your PMB.

$650 USD in 3 days
(7 Reviews)

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

$200 USD in 2 days
(18 Reviews)

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 More

$100 USD in 2 days
(26 Reviews)

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.

$800 USD in 5 days
(2 Reviews)

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. More

$2000 USD in 5 days
(1 Review)

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

$1800 USD in 10 days
(6 Reviews)

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

$1000 USD in 10 days
(0 Reviews)

hi please check you inbx

$500 USD in 10 days
(0 Reviews)

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

$200 USD in 2 days
(0 Reviews)

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

$2000 USD in 20 days
(0 Reviews)

please refer PMB for details regards Babu

$750 USD in 7 days
(0 Reviews)

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 More

$500 USD in 3 days
(0 Reviews)

Please check your P.Messages.

$1200 USD in 12 days
(0 Reviews)