Script to convert MS SQL data into mysql data for injection

  • Status Closed
  • Budget N/A
  • Total Bids 15

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 ([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.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online