Documenting your OperationsManager Database? Use SqlSpec!
Today I stumbled on a great tool for documenting your database SqlSpec 3.7 from Elsasoft.
SqlSpec will generate easy-to-read database documentation for any of the following platforms:
- SQL Server 2000, 2005, and above
- Analysis Server 2005
- Oracle 9i and above
- DB2 8.2 and above
- Sybase ASE 12.0 and above
- Informix IDS 10.0 and above
- PostgreSQL 8.0 and above
- MySQL 5.0 and above
- Access 97 and above
- VistaDB 3.0 and above
- ENEA Polyhedra 7.0 and above
You can read more about the many features of SqlSpec here.
But we as System Center specialists are probably mostly interested in our SQL Server 2005 OperationsManager, OperationsManagerDW and ReportServer databases;-)
So I connected SqlSpec to my OperationsManager database and let it run (for some time).
And when it's finished you can view you the complete OperationsManager database in a Compiled HTML file or in a Webbrowser. You even have a Dependency Graph for for instance the Alert Table. How cool is that!
If I find more interesting info with this tool about the OperationsManager databases I'll let you know.