|
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?
(comments are locked)
|
|
David, 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. Good luck, Stew p.s. I'd appreciate a vote up, so I can develop my street cred here. Thanks.
(comments are locked)
|
|
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.
(comments are locked)
|
|
Probably one of Toad's most popular features, Schema Compare (and Synch). Look forward to the competition and innovation David! We're looking forward to it too! :)
Nov 05 '09 at 08:49 AM
David Atkinson
(comments are locked)
|
|
You can try PowerDIFF for Oracle. Works for STRUCTURE and DATA comparisons. See http://www.orbit-db.com.
(comments are locked)
|
|
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 Thanks, Tom Tom Harris - Red Gate Software Ltd.
(comments are locked)
|
To clarify, as Red Gate is moving into this space, as product manager I'm curious to know what current techniques and solutions are already in use.