Tool for Organizing Your Schemas (TOYS) 1.0.38

Tool for Organizing Your Schemas (TOYS) 1.0.38 Screenshot Tool for Organizing Your Schemas (TOYS) is a useful Microsoft Windows utility for comparing, documenting and synchronizing Oracle database schemas.

Developer:   Impact Systems Pty Ltd
      software by Impact Systems Pty Ltd →
Price:  0.00
License:   Freeware
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

Tool for Organizing Your Schemas (TOYS) is a useful Microsoft Windows utility for comparing, documenting and synchronizing 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.

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
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. Supports Windows NT / 2 / 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.
  • 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.

    Limitations
  • TOYS Lite is a free version of the standard edition of TOYS.
  • TOYS Lite has a number of in-built restrictions. These are intended to allow the casual [or "lite" user] to use some of the features of TOYS without hinderance but to "encourage" serious users to support the on-going development of TOYS by purchasing the standard edition.

    Requirements
  • cle Net Client (a.k.a. SQL*Net2 / Net8 / Instant Client)

    tags meta data  you can  your schemas  schema reports  ddl scripts  code management  the original  snapshots can  source code  enables you  the tool  reference database  database this  

    Tool for Organizing Your Schemas (TOYS) 1.0.38 screenshot


    Download Tool for Organizing Your Schemas (TOYS) 1.0.38

     Download Tool for Organizing Your Schemas (TOYS) 1.0.38


    Authors software

    Tool for Organizing Your Schemas (TOYS) 1.0.38 Tool for Organizing Your Schemas (TOYS) 1.0.38
    Impact Systems Pty Ltd

    Tool for Organizing Your Schemas (TOYS) is a useful Microsoft Windows utility for comparing, documenting and synchronizing Oracle database schemas.

    Similar software

    Tool for Organizing Your Schemas (TOYS) 1.0.38 Tool for Organizing Your Schemas (TOYS) 1.0.38
    Impact Systems Pty Ltd

    Tool for Organizing Your Schemas (TOYS) is a useful Microsoft Windows utility for comparing, documenting and synchronizing Oracle database schemas.

    Free Database Compare 2.0 Free Database Compare 2.0
    StarInix Software

    The Free Database Compare software will allow you to compare the structure of two databases and display all the differences between them.

    StarInix Database Compare 2.0.15 StarInix Database Compare 2.0.15
    StarInix Software

    The StarInix Database Compare application will allow you to compare the structure of two databases and display all the differences between them.

    Free SQL Compare 1.0 Free SQL Compare 1.0
    StarInix Software

    The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them.

    SQL Server Compare 2.2 SQL Server Compare 2.2
    Yes Software

    SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas and show or save the list of differences.

    Schema Plus Lite 1.00 Schema Plus Lite 1.00
    Schema Plus

    Schema Plus Lite is an array of robust database management utilities that eliminates the need of learning numerous amounts of database management systems.

    ADX Toys 2 XL 2.0 ADX Toys 2 XL 2.0
    Afalina Co., Ltd.

    ADX Toys 2 XL is a free COM add-in that adds several useful features to Microsoft Excel.

    ADX Toys 2 OL 2.0 ADX Toys 2 OL 2.0
    Afalina Co., Ltd.

    ADX Toys 2 OL is a COM add-in that adds several useful features to Microsoft Outlook (see screenshot).

    Capxous 0.5.1 Capxous 0.5.1
    Capxous.com

    Capxous is a useful database compare tool which lets you to compare the schema of two JDBC compatible databases and quickly locates the differences in tables, views in the database to resolves database conflicts.

    ADX Toys 2 WD 2.0 ADX Toys 2 WD 2.0
    Afalina Co., Ltd.

    ADX Toys 2 WD is a COM add-in for Microsoft Word that adds the syntax highlighting of the selected source code in the current document (see screenshot).

    Other software in this category

    AppGini Freeware Version 3.3 AppGini Freeware Version 3.3
    BigProf Software

    AppGini is a tool that accelerates web database applications development.

    DBDesigner 4.0.5.6 DBDesigner 4.0.5.6
    fabFORCE

    DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

    MySQL 5.2.3 Alpha MySQL 5.2.3 Alpha
    MySQL

    MySQL is a very fast, multi-user, multi-threaded and robust SQL (Structured Query Language) database server.

    SQLTools 1.4.1 build 58 SQLTools 1.4.1 build 58
    Aleksey Kochetov

    SQLTools is a light weighted and robust tool for database development.

    BITE SQL Reports 1.01a BITE SQL Reports 1.01a
    Bite Size, Inc

    BITE SQL Reports is SQL reporting software that can be "plugged" into any existing database to add advanced reporting capabilities.