Multi-Function SQL Server Tool
SQLMetaTool is a multi-function software utility that is designed to extract
information, or more specifically metadata (data about data), from existing SQL
Server databases and to then store this information in a central
database. This central database can then be interrogated to retrieve details about the original databases in a
unified and easy to use manner. SQLMetaTool supports all editions of SQL Server 2000, 2005 and 2008
and will be invaluable for both DBAs and developers.
SQLMetaTool was originally developed for our own internal use as we could not
find anything suitable on the market. It will be of use to anyone who works
with, looks after or develops Microsoft SQL
Server databases.
Some of it’s many features include a source code repository, database object histories,
database search functions, a data dictionary including a ‘suspect’ column viewer, displays of
database settings and values, graphs of table sizes and index fragmentation and a dependency viewer.
Check out the features in more detail,
have a look at the screenshots,
try out the free evaluation download and see what you think.
How does it work?
A central database is created on an existing SQL Server instance. Selected target
databases are then scanned, either manually or on an automated schedule, and the
results are stored in the central database. These results can then be viewed from any machine that can
see the central database. Target databases can be on the same instance, a different
instance or a completely different server.