When I started working with Salesforce.com and setting up these database replication jobs, I had no idea where to start on the database structure. Please understand that I am not a DBA by any means and would never begin to understand a job such as that. I had no idea what the data types meant when I read the API documentation and not one single clue on how I was going to setup a local database structure from our instance of salesforce.

At first I would have thought, and still do to this day, that salesforce should be leading the way in this and possibly have some sort of database scheme for the standard objects/tables that are used in Sforce. I searched all over the developer network or other sites for such things as tutorials or example schema's or an idea on where to start. Not one of the people from developer's forum at Sfroce would help or even hinted on what I needed to do. I like to help people (to a certain point) and starting from this entry I am going to be showing some examples of database schemas for both Oracle and MySQL.

The schema examples will come from my developer account. So let's get to it! I will start with the Opportunity object and post two snippets in replies to these threads and then I will attach a zip file that will have two files in it. Each schema has been tested in both MySQL and Oracle 10g, both table creations will work.

I will be doing most of the main objects/tables and I hope this helps the community

If anyone has any comments or questions please use the contact form on this site or join the community and let me know your thoughts

Mike
6/27/07