TOYS Product Page

TOYS	the Tool for Organizing Your Schemas

TOYS Product Overview

TOYS comes in three flavors that are distinguished by the type of license you have.

Free (unlicensed)

You may download and use TOYS for free. You are not required to register or provide any information. Please note that without a license TOYS does have restricted functionality. See TOYS Feature Summary for a list of [un]supported features.

For more detail see What is the free edition of TOYS?

Lite edition

The lite edition of TOYS allows you to perform unrestricted schema capture, schema differencing and schema reporting. See TOYS Feature Summary for a list of supported features. Note that until the release of the professional edition schema synchronization will also be enabled in the lite edition.

Professional edition

The professional edition of TOYS supports schema synchronization in addition to the features supported by the lite edition [see TOYS Feature Summary for a list of supported features].

Synchronization functionality is still under development. The main feature lacking is the ability to selectively synchronize parts of schemas / objects. Because we consider this functionality is incomplete we do not currently sell licenses for the professional edition. However since many of our customers actively use the synchronization functionality of TOYS we have enabled it in the lite edition until the release of the professional edition.

Functions

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.
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.

Checkout a sample Differences Report.
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 [not available in free edition]
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.
Schema Synchronizing [professional edition only]
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.

Features

Easy to use GUI. Supports Windows® NT / 2000 / XP. See System Requirements for details of the hardware and software requirements of TOYS.
Non intrusive. That is, no special setup is required within the accessed databases. TOYS does not install objects into the database when capturing schema information. This is most important if you have lots of databases.
Simple setup. TOYS installs in seconds. It does not require ODBC or the setup and maintenance of database repositories. TOYS only requires that the Oracle® Net client be installed. See Installing TOYS for details of installing and running TOYS.
Fast operation. Comparisons only take seconds. Similarly, snapshots are loaded (or saved) in seconds. This can save a significant amount of time when comparing a large number of databases. Retrieval of schema meta-data from the Oracle® catalogs (snapshot capture) has been optimized to further speed the process.
Support for Oracle® 7, 8, 8i, 9i and 10g.
Supports multi-schema operation. Multiple related schemas within a database can be captured, compared and synchronized as a unit. TOYS is not limited to single schema comparisons and upgrades.
Easy monitoring of schema changes. Schema meta-data snapshots are saved by TOYS as XML and can be quickly retrieved and compared against existing schemas or other saved snapshots. This facilitates tracking all schema changes to any of your databases.
Operability with source code management tools. Snapshots are saved by TOYS as XML and can be stored as text in any source code management system.

Screenshots will show you what the GUI looks like.

A quick tour of TOYS takes you for a tour of some of these features.