function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AnjandeepAnjandeep 

1. How to extract salesforce database and the data to upload another database

pkurapkura

There are some tools provided by salesforce for this purpose. You can start with dataloader http://wiki.developerforce.com/page/Data_Loader which allows you to extract  data from salesforce in to .csv format which can be uploaded to another database.

Another option is to use force.com API to create webservice connection and extract the data into the format you need (XML, JSON) and write another program that uses JDBC to connect to Oracle or mysql or any other database that you want to upload. I would start with the volume of data that you need to extract and based on the volume use the appropriate solution.