Export data from MS SQL server to mySQL

[Baldinato]

Hi!

I use Sugar 5.0, Apache, Mysql on windows server 2000. I have created a php script that extracts data from a MS SQL server and insert into a mySQL.

Now I wanna creata a scheduler to execute it in automatic manner.

I try in different manner but i don't resolve. Any idea?

Thanks,

Christian

[eNick]

Are you using linux or MS based server?

The scheduler set up is slightly different for each.

[Baldinato]

Hi!

I use Windows 2000 Server.

Thanks,

Christian

[eNick]

First you need to create a batchfile, so something like schedule.bat, which contains the following two lines...


cd C:\<path to your sugar root folder>
php.exe -f cron.php

Then you need to set up the microsoft scheduler to call that batch file periodically.

Finally, you need to ensure you have your export/import job set up in the scheduled tasks in admin->schedulers

Nick

[eggsurplus]

See http://www.sugarcrm.com/wiki/index.p...ux_or_Mac_OS_X as well for more information.