VMware Cloud Community
gcarmichael
Contributor
Contributor
‎03-05-2007 12:25 PM

Database schema

Can someone point me to where I can find the database schema for VC and a description for all the fields in the tables? I've done some quick searches and I wasn't able to find any references, but I want to be sure I've covered all my bases.

Thanks,

Gary

0 Kudos
5 Replies
gcarmichael
Contributor
Contributor
‎03-05-2007 02:20 PM

I've opened a SR for this as well. I'll post when I receive a response.

Gary

0 Kudos
Jae_Ellers
Virtuoso
Virtuoso
‎03-05-2007 02:33 PM

What are you trying to do?

Hammering on the data directly would probably be frowned upon by vmware.

I'd suggest looking at the vmware programming and scripting apis http://www.vmware.com/support/developer/ and the perl toolkit http://sourceforge.net/projects/viperltoolkit to do your own thing.

Otherwise, crank up visio and point it at the sql server and let visio document the schema for you.

There used to be some references to the views in the db, but I can't find them online anymore. This question was asked a couple months ago. http://www.vmware.com/community/thread.jspa?messageID=544102&#544102

-=-=-=-=-=-=-=-=-=-=-=-=-=-=- http://blog.mr-vm.com http://www.vmprofessional.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
0 Kudos
gcarmichael
Contributor
Contributor
‎03-05-2007 02:37 PM

Thanks for the reply Jae. I need to document what each field is for every table in the database. I was hoping a schema document would tell me that. That's something Visio won't do.

I'll check the APIs, thanks for the suggestion.

And don't worry, I'm not hammering on the data directly. I'm not foolish enough to do that Smiley Happy

Gary

0 Kudos
Jae_Ellers
Virtuoso
Virtuoso
‎03-05-2007 03:10 PM

after quite some digging I found http://www.vmware.com/pdf/vc_dbviews.pdf which seems to be newer version of http://www.vmware.com/pdf/vc_dbviews_11.pdf.

However, this is just on setting up some 1.x views and not really on the internal tables. As said before, it seems pretty logical.

Also, have a look in the vpx.cab file in the VC 2 binaries. It contains some useful things like CreateVC20.sql. But I think Viso is quicker to get started.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=- http://blog.mr-vm.com http://www.vmprofessional.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
0 Kudos
gcarmichael
Contributor
Contributor
‎03-07-2007 07:11 AM

I recevied word back from the SR I opened that the database schema is not published. They referred me to the dbviews.pdf file Jae mentions, but that to only look at the data.

So Jae, thank you for your suggestions, but it looks like this is a question that can't be answered.

Gary

0 Kudos