You need to sign in to do that
Don't have an account?
Jay Eckles
Creating SQL Server tables to backup Salesforce data
I am setting up a series of Data Synchronization Tasks in Informatica Cloud that copy data from Salesforce objects into SQL Server tables. The most time-consuming part of this exercise is creating the tables in SQL Server. Is there any way to ideally automatically build T-SQL DDL or second best to get the names and types of all fields for each object in Salesforce?
I have tried using the XML files for objects that is accessible via the Force.com IDE, but those XML files seem only to contain the custom fields and they are in a terrible format for this purpose anyway. The data is also available via salesforce.schema in the Force.com IDE, but only in an "explorable" format, not in any structured downloadable format.
Is there an API that Force.com IDE is using that I can leverage to get the metadata I'm looking for? Am I coming at this from the wrong angle entirely?
You are not coming from any wrong angle. This is very logical request and problem that many have.
I believe Informatica cloud can replicate the DDL along with the Data so please check once again and see if you can leverage that.
I don't know of any tool which can generate the sql based on the schema. The tool Real Force Explorer (https://bitbucket.org/brsanthu/real-force-explorer/wiki/Home) can show the list of all objects, field names and types. May be that would be of some help.
For a trial copy, email me at rhard2651@gmail.com