About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Shareware
  • Last update: 5 years ago
  • Total downloads: 124
  • Price: 289.00 to buy | | BUY the full version
  • Operating system: Win All
  • Publisher: Impact Systems Pty Ltd
See full specifications

windows default iconTool for Organizing Your Schemas Publisher's description

A tool for comparing and synchronizing Oracle database schemas

Tool for Organizing Your Schemas (TOYS) is a useful Microsoft Windows utility that helps you compare and synchronize Oracle database schemas.

The tool facilitates taking snapshots of the database structure (meta-data) and saving these snapshots as XML files. Snapshots can be compared to determine what has changed over time.

The tool facilitates synhronizing database structures with snapshots or other live databases.

The tool also supports the creation of HTML schema reports and the generation of DDL scripts to re-create your schemas. Snapshots may be saved as standard text files (as XML) in source code management tools. Supports Oracle 7, 8, 8i, 9i and 10g.


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.

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.

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

Here are some key features of "Tool for Organizing Your Schemas (TOYS)":

В· Easy to use GUI

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

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

What's New in This Release:

В· Minor fixes

System Requirements:

В· Pentium III/500 MHz or better recommended
В· 256 MB of physical memory
В· 512 MB of virtual memory
В· 10 MB disk space
В· Oracle net client
В· Microsoft HTML Help support
В· An up to date internet browser


В· Support for renamed objects disabled
В· Command line operation disabled
В· Generation of DDL scripts to synchronize schemas disabled
В· Places restrictions on browsing and reporting of differences for large databases. When the number of objects in your database exceed certain limits TOYS will not allow you to view details of an object's differences or to create a difference report. This restriction does not prevent you seeing which objects are different but it prevents you from seeing the details of those objects which are different. Restrictions are not applied providing your working database snapshot contains a single schema that has no more than 50 of the following object types: tables, views, types, packages, procedures.
Program Release Status: Major Update
Program Install Support: Install and Uninstall

Tool for Organizing Your Schemas Tags:

Click on a tag to find related softwares

Is Tool for Organizing Your Schemas your software?

Manage your software

Most Popular

windows default icon Bill Scale and Balance Wedge Keyboard 6.0B
Inputs scale and balance data directly into any Windows programs
windows default icon P7S Viewer 3.1
P7S Signer is a standards-based electronic signature solution Signing electronic documents with P7S Signer
windows default icon English to Hindi Character Converter 9.0
English to Hindi typing software. Its works as you speak Hindi language.
windows default icon EX4-TO-MQ4 decompiler 2011
EX4-TO-MQ4 decompiler (support MT4 225 build) - Decompile and protect MQL compiled files Currently I am
windows default icon TickNTick for Windows
TickNTick (Windows Based) Application is a powerful analytical tool with advanced charting features.