View Single Post
  #6  
Old 05-22-2008, 06:49 PM
mike mike is offline
Administrator
 
Join Date: May 2007
Posts: 273
Send a message via AIM to mike Send a message via MSN to mike Send a message via Yahoo to mike Send a message via Skype™ to mike

Quote:
Originally Posted by aaron View Post
I just wanted to do everything to make sure I was never missing anything. I suppose I don't need every table, I just thought it would be easier that way.

So my question is why is it necessary to have a separate script for each table? It looks like a generic data copy script could be written using the same methods as the schema copy script. Have you come across some reason why each object must have it's own explicit script in which all fields are hardcoded?
It is not necessary if you want to build such a script, I just find it more manageable to do it this way.

BUT let's say you do it your way and create one script to download all your fields from an array of 10 tables and during the process something fails in the script, like a lost connection to Saleforce (which has happened) or you have a large dataset in salesforce (like 150,000 records). Let's say it happens in the third object during your script run, well the other 7 will not replicate

Anyway, You can go about it anyway you wish man, I am just trying to give you advice that works for me and has never failed. Your way may work just fine and if it does, I hope that you share your results with all the rest of the PHP developers in the Salesforce community

Anyway I hope that gives you some guidance in your search for a replication system

All the best

~Mike
Reply With Quote