I need to extract data out of SalesForce and into an MS SQL database. Is there a way to automatically generate the salesforce object SQL table structure? I would like to generate a SQL create table script with some of the salesforce objects. I can then use that table to send my data to SQL.
Salesforce uses the SOQL language for queries, therefore you cannot directly extract from salesforce using SQL. In most cases I have seen, users extract files from Salesforce using SOQL queries perform transformations on that file of data and then uploads that data to their database, the automation of this can be done using an ETL tool or writing code to perform these processes. I hope this helped.