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.
14 freelancers are bidding on average $854 for this job
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.