We have SugarCRM application (MySQL Database), and later on, daily, we need to import from SQL Server to the MySQL database. This needs to be done automatically (scheduler)
My questions :
What is the best way to do that? and we don't have any budget to buy MySQL Export Import tool
I think there are some alternatives :
- Make that the SQL Server to export to MySQL
- Make a PHP funtion that read from SQL server and write it to MySQL, The make CRON job to schedule the job.
- Is there any other alternative to do that?