Features
SQLMetaTool
is a multi-purpose software tool for use by anyone who works with, or
looks after, Microsoft SQL Server databases (2000, 2005 and 2008 versions).
It has a wide range of functions and features including:
How Can It Help Me?
With SQLMetaTool you can...
- Recover an earlier version of a stored procedure, even if it's been deleted.
- Compare the current version of a stored procedure with an earlier one and highlight any changes.
- Find all references to a text string throughout a database definition.
- View a summary of essential information about your databases (sizes, recovery models, last backup dates, compatibility levels, etc.)
- View a list of changes over time to an object, such as a table or a UDF.
- View dependencies in a colour coded treeview display.
- List all columns for a specific data type.
- Automatically identify 'suspect' column data types, such as columns with the same name but different sizes, data types or collations.
- View a graph of database size over time (data, log and total).
- Identify fragmented indexes and generate T-SQL rebuild or reindex scripts.
- List tables by size and by number of rows.
- View a graph of index sizes.
- View a data dictionary including schemas, column names, data types, sizes, collations, constraints and FK details.
- Schedule automatic rescans of your databases and/or use manual scanning.
SQLMetaTool is a passive utility - it does not alter any of your existing databases, although you can
generate scripts which can be applied to change your databases.
Some of the functionality, such as searching and recovering T-SQL definitions,
of course does not work for encrypted objects.