Replicate Salesforce Schema to Oracle or MySQL

Mike Simonds released 2 scripts over the past few days that will create copies of your Salesforce schema into MySQL or Oracle databases. I haven’t tested either of them, but I think this could be pretty handy. Of course, you’ll need to have additional scripts actually bring your data over from Salesforce to these databases, but this is a start. Learn more about the scripts using the links below.

If you try these, feel free to comment here about how it went. If you actually want to let Mike know about your use of the scripts, you could submit replies on his site or at his forum postings about the functionality (Oracle, MySQL)

10 Comments

  1. David Claiborne Said,

    August 9, 2007 @ 11:10 pm

    Mike and I collaborated on the scripts. I took a little different approach, creating a private AppExchange product that you can load and then generate the script via a web-link custom tab.

    You can install the web link via AppExchange from https://www.salesforce.com/appexchange/detail_overview.jsp?id=a0330000003gIkrAAE

    The product is free.

  2. Mike Simonds Said,

    August 11, 2007 @ 2:39 am

    Yes sir we did collaborate on these scripts and David has taught me so much about working with Salesforce, PHP, and the API. His first MySQL schema script was really an accomplishment. Thank you Dave!

    Listen thanks Scott for putting up the links, I really appreciate it

    I am adding another part to MySQL script that will even go and now try and create the database. It is done, but I have to test it more.

    Yes the product is free

  3. Chris Said,

    August 13, 2007 @ 6:51 am

    Shameless plug coming:

    Bluewolf’s Data Replication Engine will move both data and schema to the ANSI SQL-compliant database of your choice, with lots of nifty options including scheduling and just grabbing deltas of data. Good for backups or moving data into neutral territory for analytics or warehousing.

    Not free, but industrial strength when it’s your company’s vital resources (and budget).

    On the AppExchange:
    http://www.salesforce.com/appexchange/detail_overview.jsp?NavCode__c=&id=a0330000000OLNAAA4

    30 day free trial!
    http://www.bluewolf.com/on-demand-solutions/salesforce-applications/integration-solutions-product/dre

    (New version coming soon with top improvement requested by customers!)

    Shameless plug concluded. Thank you for your time. 😉

  4. David Claiborne Said,

    August 14, 2007 @ 4:10 pm

    If you are going to post a shameless plug, don’t be ashamed to state the price – $8,500 a year.

  5. Mike Simonds Said,

    August 22, 2007 @ 5:44 pm

    My company tried to implement Blue Wolf’s ESI tool which is a great piece of software and while we were trying to work on the install some issues came up with the requirements. After that we jumped the ESI tool for PHP. We were offered the DRE tool during the requirements phase of the ESI install but after hearing the price, $10 K a year, we decided to use PHP.

    You can replicate exactly what you need to do in PHP:
    !) Create database replication scripts that run on CRON which download and populate your entire table from what ever object you wish in salesforce.
    2) Why pay this amount a year when you can do it for free, PHP is free!
    3) The DRE tool is written in Java, PHP is much better for ease and use in my opinion.

    If you use the two tools from BlueWolf, the ESI and DRE, you would pay over $80 K a year.

    OR

    You can take the time to develop your own replication system in PHP for free, which does the same exact thing. I have the required tutorials on my (so-called) blog that gives examples of how to set this up from scratch

    There is no comparison in my mind
    Just my two cents

    Thanks
    ~Mike

  6. Jonathan Snyder Said,

    August 23, 2007 @ 12:24 pm

    We are using Relational Junction by Sesame Software to move data back and forth from SF to Oracle. We are running constant updates (every 10 minutes or so) as we have some more complex formulas running in Oracle and feeding various SF fields. I have found that the combination of SF and Oracle provides unlimited functionality.

    We are paying about 8k per year for RJ – but it required very little setup and has worked nearly flawlessly for a year now. While I am sure we could have written the scripts to do the job – I think that the time saved for the initial development and the time required to keep the tool in synch with SF changes has made the decision worthwhile. In our case, we have a small IT team with way to much to do already – so we find that Buy wins over Build in most cases for us.

  7. Tammy Said,

    July 21, 2008 @ 2:42 pm

    I have my DBA’s looking at this now to determine if we can run PHP scripts here.

    Question….will this script result in an error if we run into the 10,000 character (or whatever) constraint with soql??? Our Account object is HUGE!!

    Thanks, Tammy

  8. Scott Hemmeter Said,

    July 21, 2008 @ 2:52 pm

    @Tammy:

    I suggest you ask your question over at http://www.mikesimonds.com/. The expert on these scripts is over there.

  9. Raghu Said,

    October 14, 2008 @ 1:14 pm

    Hi, I tried using David Claiborne’s appexchange app on our sfdc org but I am getting the following error. Could someone help me out pls

    Fatal error: Uncaught SoapFault exception: [sf:LOGIN_MUST_USE_SECURITY_TOKEN] LOGIN_MUST_USE_SECURITY_TOKEN: Invalid username, password, security token; or user locked out. Are you at a new location? When accessing Salesforce–either via a desktop client or the API–from outside of your company’s trusted networks, you must add a security token to your password to log in. To receive a new security token, log in to Salesforce at http://www.salesforce.com and click Setup | My Personal Information | Reset Security Token. in /home/claico22/public_html/datasynch/soapclient/SforceBaseClient.php:113 Stack trace: #0 [internal function]: SoapClient->__call(‘login’, Array) #1 /home/claico22/public_html/datasynch/soapclient/SforceBaseClient.php(113): SoapClient->login(Array) #2 /home/claico22/public_html/datasynch/inc/adminUser.inc(15): SforceBaseClient->login(‘claiborne@claic…’, ‘quin2by’) #3 /home/claico22/public_html/datasynch/dshome.php(33): AdminUser->__Construct() #4 {main} thrown in /home/claico22/public_html/datasynch/soapclient/SforceBaseClient.php on line 113

  10. Adam Said,

    March 11, 2013 @ 11:50 am

    Another plug here – an additional option is cloudconnect.com; unlike the other options listed here is a true -as-a-Service offering, so you all you need to do to get started is enter your salesforce credentials. Cloudconnect.com will provision and manage the database (Heroku or AWS), and will maintain a near real-time bi-directional synchronization.

RSS feed for comments on this post