2007 Published database layout/schema

[Kerry]

I've searched the internet. Can anyone tell me where I can find documentation
on the published database layout?

 

[Dale Howard [MVP]]

Kerry --

You need to download the SDK, which includes the Reporting database schema:

https://www.microsoft.com/downloads...f9-7028-4b30-99a2-18cb1eed1abe&DisplayLang=en

Hope this helps.

 

[Jonathan Sofer [MVP]]

Unfortunately, querying the Published Database directly is not supported by
Microsoft so they do not publish documentation as to the layout of this
database. I am also not aware of any other source of documentation on this
database. The way I have done it in the past is through trial and error.

The reporting database schema is available with the SDK download like Dale
suggested.

Hope this helps,

Jonathan