I've been working towards exporting the Salesforce Schema via the Partner API to SQL Server. The current export is starting to look a lot like the Salesforce supplied ERD.
Note that most of the Status/Stage objects are disconnected when using the Partner API as the data has been denormalized. Also, the Partner object isn't exposed via the Partner API.