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.