Cast Iron Helps with Huge Salesforce Migration

Rapid Integration recently completed a six month project involving the migration of over twenty million records between two Salesforce.com organizations. The project used a combination of the Salesforce Bulk API and a Microsoft SQL Server database for staging. Using a Cast Iron horizontal scaling design pattern, we extracted the entire data set from Salesforce in 90 minutes. To make this all work, we learned a few new Salesforce API techniques, and we made some Cast Iron tweaks to improve the SOQL query performance.