TOYS Feature Summary

The following table lists the major features of TOYS and indicates which edition has that feature.

Feature	Free	Lite	Pro
Capture and archiving of schema meta-data (snapshots) Schema meta-data is captured as "snapshots". These "snapshots" can be saved to disk as XML and facilitate schema versioning and operability with source code management systems.
Generation of DDL scripts to re-create schemas. DDL scripts can be generated from "live" databases or from any archived snapshot. These scripts support re-construction of complete databases at any point in time.
Creation of HTML schema reports.  [not currently available] HTML reports can be generated from "live" databases or from any archived snapshot. This format supports both intranet and internet publishing of schemas.
Schema browser. Supports browsing "live" databases or any archived snapshot.
Compare schemas. "Live" databases can be compared with each other or with archived "snapshots". "Snapshots" may also be compared with each other. Differences are displayed in a tree view showing additional, absent and changed objects.
Multiple schema support. TOYS can compare and synchronize multiple schemas as a single unit. See side-bar for restrictions in the free edition.
Support for an unlimited number of objects. Up to the limits imposed by memory, TOYS can capture, compare and synchronize an unlimited number of objects. See side-bar for restrictions in the free edition.
Creation of HTML difference reports. Database differences can be published as HTML. See side-bar for restrictions in the free edition.
Support for renamed objects. Ability to explicitly handle re-named sequences, tables and table columns when comparing and synchronizing.
Command line operation.  [not currently available] Many of the basic features of the GUI tool are able to be executed from the command line. This allows schema capture and comparisons to be scheduled using the Windows task manager.
Generation of DDL scripts to synchronize schemas. Creates DDL scripts that synchronize the working database with the specified reference database. Data is transformed or preserved as necessary.
Direct synchronization of schemas.  [not currently available] Provides an alterative to generating and executing DDL scripts. Databases are synchronized directly by TOYS.
Creation of synchronized archives.  [not currently available] Supports non destructive synchronization by creation of "synchronized" archives. This is achieved by making a "transformed copy" of the existing database.
Export of data in SQL*Loader formats.  [not currently available] Writes data (including control files) in formats that are readable by the Oracle® SQL*Loader utility.
Export of data in EXP/IMP format.  [not currently available] Writes data in a format that is readable by the Oracle® IMP utility.