You need to sign in to do that
Don't have an account?
John Flint
Converting an Enterprise WSDL to SQL Create statement
I am trying to find a quick way to create tables in a SQL database that mirrors the confgiuration of objects in Salesforce. It is easy enough to generate an enterprise WSDL that shows that the current object structure. Does anyone know of a tool that will convert it to a SQL create statement? Any other suggestions on how to quickly generate tables for a SQL based database so you can load a mirror of your data?
So I tend to ignore anything Enterprise WSDL and always go with Partner. I can't expect this to be too hard, but I've never tried to do this myself. Getting a list of the objects is a query that is there but I don't remember what it is. Some kind of GlobalDescribe or maybe it's in the MetaData.
Everything else is somewhat simple. I wish I had my old cost that would render HTML based on the results of a query, but that's tucked away somewhere in the old SVN code and I don't feel like digging it out. Anyways, everything relies on the DescribeSObject call.