I have been tasked with pushing Google Analytics data periodically to SQL Server 2005 running on a different server from various websites (about 450 of them) grouped on various servers. I understand I can run PDO queries with PHP to write to the SQL Server DB, but I'm unclear about the second part, doing it periodically. The client wants the data pushed hourly for some data and daily for others.
Would setting up a cron job be the best way to do this? Would I have to add the PDO snippet to each site I want to push data from, or can I run the query for multiple sites from one location on each server? Are cron jobs and PDO the best way or is there a more practical way?