I have encountered some errors while doing this due to some tables/objects being so large that the php scripts are timing out and cannot finish their downloads from Salesforce.com. Each table download has its own script and, as I have stated before, some of data in these tables have large values.
An example of the problem lies in the Opportunity object, which has over 50,000 records, with 40 plus columns. You can imagine the amount of data that is being downloaded. If the scripts are not written properly, your script will timeout
I am going to continue to develop these scripts and see if I can get a clean run without a timeout over a weeks time. If the scripts can run for a week, multiple times a day (so the data in the locale Oracle database will remain fresh) and run without any such error or timeout that may occur
Mike
|