Script to convert MS SQL data into mysql data for injection

CANCELLED
Bids
15
Avg Bid (USD)
$830
Project Budget (USD)
$100 - $2000

Project Description:
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 (www.sigsiu.net) 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 required:
Perl, PHP, Shell Script, Software Architecture, SQL
Hire wodfer
Project posted by:
wodfer Norway
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire Mindon
$ 500
in 5 days
$ 250
in 2 days
Hire stevearm
$ 650
in 3 days
$ 200
in 2 days
$ 100
in 2 days
Hire alexstech
$ 800
in 5 days
Hire devexperts
$ 2000
in 5 days
Hire spykecoders
$ 1800
in 10 days
Hire kostasbre
$ 1000
in 10 days
Hire mostafabahaloo
$ 500
in 10 days