function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Payoda SFDCPayoda SFDC 

Automated data import/export between SFDC and SQL database

Hi,

We wish to know about some tool that facilitates automatic data import/export between SFDC database and SQL database on a button click. Please let us know of any such tool available.
RamuRamu (Salesforce Developers) 
see if this tool helps

http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/
Scott HungScott Hung
You might want to check out Heroku Connect:  https://www.heroku.com/connect

Unfortunately, it syncs between SFDC & POSTGRES (not SQL), but it's tough to beat a native tool created/supported by Salesforce themselves.  I think the writing is on the wall with the release of this tool and the fact that Salesforce owns Heroku...
Jamie MartinJamie Martin
For bi-directional import/export between SFDC and SQL database (MySQL, PostgreSQL, SQL Server, SQLAzure and Amazon RDS) I can recommend you cloud-based service  - Skyvia (https://skyvia.com/connectors/salesforce).

It is a completely no-coding solution with flexible scheduling features and intuitive user interface.
richard harding 1richard harding 1
I have a process/tool that exports Salesforce data to sql databases (MS,MYSQL or ORACLE).
 For a trial copy, email me at rhard2651@gmail.com
SergeiSergei
Take a look at this article: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server
It shows top 5 ways how to automate data export/import between Salesforce and SQL Server with no coding skills.