Meta-data Capture
TOYS enables you to extract schema definitions [meta-data] out of your existing database.
Meta-data Archiving
TOYS lets you save these extracted schema definitions [called "snapshots"] as XML files.
Snapshots files can be quickly loaded for comparison, reporting or DDL generation.
Schema Reporting [available soon]
Snapshots can be used to generate various forms of schema reports, customisable by using XSLT stylesheets.
Default stylesheets are provided for generating regular HTML schema reports and for generating
Microsoft® HTML Help files.
DDL Generation
Snapshots can also be used to generate DDL scripts. These DDL scripts allow you to clone
or re-create your schemas.
Schema Comparison
Using TOYS you can compare the schemas in any of your databases with their counterparts
in your other databases.
Alternatively you can compare your databases with any "snapshots" you
have saved previously. You can even compare saved "snapshots" with each other.
Publishing Schema Differences
You can save the results of schema comparisons as XML. A XSLT stylesheet is provided
that enables you to publish your schema differences as a HTML "tree view" report.
Checkout a sample Differences Report.
Schema Synchronizing [a work in progress]
TOYS can generate DDL synchronization scripts to upgrade your working
database to agree with your reference database. These scripts alter the schema structures
as necessary and preserve existing data.
Synchronized Copying [not currently available]
TOYS enables you to create a "synchronized" copy of your database.
This means that you can keep the original database and make a copy of it
as an archive that is "synchronized" with the reference database.
This is an archive of the original database altered to the new structure.
This archive can be loaded into an Oracle® database to construct an
"updated" copy of the original.
Screenshots will show you what the GUI looks like.
A quick tour of TOYS takes you for a tour of some of these features.