If you ever have to compare schemas and create migration scripts how do you do it? Do you have a tool that works well for you or do you do this by hand?
asked Oct 27, 2009 at 11:34 AM in Default
I'm a fan of PL/SQL Developer from Allround Automations. This includes a basic schema object comparison tool and can copy object definitions between schema. I use it occasionally for comparing and copying selected objects, rather than entire schema.
I should also note that I'm a developer, not a DBA, so my need for and use of such tools is limited.
p.s. I'd appreciate a vote up, so I can develop my street cred here. Thanks.
answered Oct 29, 2009 at 12:12 PM
Our DBAs use Oracle Enterprise Manager for schema compare. For Schema upgrade we use a home grown system where developers write incremental schema change scripts, check in version control and the CI build runs all the change scripts. A record of which scripts have already been run before are kept in a table and they are not run again. Stored Procs, functions etc are always overwritten with the latest version in each build.
answered Nov 05, 2009 at 05:14 AM
Probably one of Toad's most popular features, Schema Compare (and Synch). Look forward to the competition and innovation David!
answered Nov 03, 2009 at 03:48 PM
Red Gate now has Schema Compare for Oracle available for download. The tool is designed to compare and synchronize the schemas of Oracle databases. Version 1.1 of the product suppports Oracle 9i, 10g and 11g
Download your 14-day free trial from http://www.red-gate.com/products/schema_compare_for_oracle/index.htm
Tom Harris - Red Gate Software Ltd.
answered Jun 17, 2010 at 12:47 PM