You need to attack problems like this at the source, even if that means, redesigning the production database schema.
How do you shorten the amount of time that it takes to run invoicing when you can't touch either the database schema or the invoicing application?
Due to how the database schema was constructed, early database design decisions were hampering organizational growth.
Embarcadero Schema Manager automates and streamlines the complex and error-prone task of maintaining application database schemas on multiple platforms.
Interactively view the union, intersection and differences between two or more database schemas.
Perform drill-down analysis of the differences between database schemas.
We're excited to now offer the community a chance to experiment with the Database Schema Provider beta and discover the value this tool will bring to Visual Studio Team System 2010.
Download Quest's Database Schema Provider beta: http://teamfuze.
Also, the ability to custom tailor HTML screens with our semantic mapping strategy or support different database schemas
DB Copy Expert can be used to copy and migrate schema objects and entire schemas between Oracle databases; copy tables with and without data; copy samples of production data to development or QA environment; copy entire database schemas
The Zend Query Editor allows developers to execute queries on connected servers, connect live to several servers at once, view database schemas
and manage content.