WT1 - Server Console
|
monitor connections
monitor SQL Agent jobs
check space allocation details
|
Screen Shot 1
Screen Shot 2
Screen Shot 3
|
WT2 - Database Differences
|
compare field definition
compare table structure
compare SQL code and clone SQL code
|
Screen Shot 1
Screen Shot 2
|
WT3 - Database Documentation
|
show object dependencies and find text in object SQL code
generate HTML pages listing database schema details
generate SQL script for existing database objects
|
Screen Shot 1
Screen Shot 2
|
WT4 - Import & Export
|
truncate tables with automatic handling of all foreign key constraints
import/export and compare/patch tables using binary files
generate SQL script containing data from tables
|
Screen Shot 1
Screen Shot 2
|
WT5 - Analyze & Correct
|
analyze data in fields by distribution of values or ranges of values
reset IDENTITY values and remove gaps in the sequence
find duplicate records and resolve the duplications
|
Screen Shot 1
Screen Shot 2
Screen Shot 3
Screen Shot 4
|
WT6 - Audit & Restore
|
establish auditing on tables
examine audit trail
restore data
|
Screen Shot 1
Screen Shot 2
Screen Shot 3
|
WT7 - Relational Data
|
compare/patch single tables between databases
copy/patch database branches (parent records and all children)
generate SQL script to compare/patch many related tables between databases
|
Screen Shot 1
Screen Shot 2
Screen Shot 3
Screen Shot 4
|
WT8 - Database Architecture
|
generate SQL script for standard triggers and stored procedures
generate SQL script for standard keys and indexes
generate SQL script for table definition
|
Screen Shot 1
Screen Shot 2
Screen Shot 3
Screen Shot 4
|