I created and modified a script that allows for you (the user) to create a MySQL schema of your salesforce.com instance. The script requires the following:

• Salesforce login
• Salesforce Password
• Salesforce Key
• Prefix of tables (e.g. sforce_)
• name of file (e.g. file.sql)

You will need your key for this tool. If you do not have your key, it will not work. If you need to reset your login key, you need to do this:

1. Login to your instance of Salesforce.
2. then go to Personal Setup
3. then go to Reset My Security Token

The token will be sent to the email that you have on file with salesforce.com.

To test this, please click here

I would appreciate feedback on this to see what people think or if it even works for you

~Mike

My friend Mike!

I just tested it and it worked like a charm!
I got the standard objects and all custom as well...

Great job man!!

lachof

Thanks for testing it dude, i appreciate it.

I have tested it from 3 different ISP's and it worked just fine. I only wish there was a way that a user did not have to use their security token to login. To me, it is a pain in the ass, but there is nothing that I can do about that part of the script.

I get tons of emails asking things like:

How do I create a MySQL schema?
Where can I get a schema for my salesforce instance?
and others

Not sure it will come in handy at all, but I thought that it would be something that someone may use

Anyway man, thanks for testing it for me

Perfect tool to help understand the mapping from Custom Object field names to API field names -- Thanks a bunch!

Peter.

Great Peter I am glad that you found this useful. Thanks for taking the time to post in this thread