Page 1 of 1

cronjobing .DAT files into MySQL

Posted: Fri Jun 06, 2008 1:06 pm
by davidcitron
Hello all,

i have got an issue with a client here, who is running an internal CRM system.

we need to get information into our Webserver (Linux-MySQL5) database (dealer lists, product lists, ....) and this information is stored in the CRM.

but the CRM is Windows-MSsql. The output is .DAT files.

Best would be able to do it all on our server side, simply asking to get the .DAT each day by cronjob .... possible ?

If option above is not possible, what are my best options here ?

Please do not hesitate to contact me if you have professional advice/proposition.

All the best, david