Schema Compare for Oracle

Schema Compare for Oracle is the fast way to compare and deploy Oracle schemas. With the software you can identify differences between your largest environments within minutes smaller schemas take seconds to compare, eliminate mistakes migrating database changes from dev, to test, to production, compare multiple schemas and schema objects with creation scripts, use in conjunction with Source Control for Oracle, deploy databases from source control, command line automation and run Schema Compare for Oracle on your build server for continuous integration (with the Deployment Suite for Oracle).

Key Features:

• View schemas side-by-side
  • Drill down into the DDL for each object in your schema to see highlighted differences.
  • Filter by object or type an object name to find it fast.
  • Compare databases, snapshots and scripts folders. Easily find and fix errors in deployment.
    
• Deploy schema updates
  • Automatically create error-free synchronisation scripts to deploy only the schema changes you want.
  • Get deployment notifications about dependencies, truncations and other issues.
  • Deploy using Schema Compare or your IDE or save a SQL script to share with your team.
    
• Work with the command line
  • Carry out any task using the command line tool.
  • Automate scheduled tasks like comparisons and deployments for continuous integration.
    
• Output schemas to a scripts folder
  • Create scripts folders of your schemas.
  • Objects are exported as individual creation scripts and arranged in folders by type, so the structure of your database is maintained.
    
• Source control your schemas
  
  • Use Schema Compare for Oracle with Source Control for Oracle - which makes the process of checking database changes into SVN or TFS as simple as typing a comment.