<p>We're a .NET team which uses the Oracle DB for a lot of reasons that I won't get into. But deployment has been a bitch. We are manually keeping track of all the changes to the schema in each version, by keeping a record of all the scripts that we run during development. </p>

<p>Now, if a developer forgets to check-in his script to the source control after he ran it - which is not that rare - at the end of the iteration we get a great big headache.</p>

<p>I hear that SQL Compare by Red-Gate might solve these kind of issues, but it only has SQL Server support. Anybody knows of a similar tool for Oracle? I've been unable to find one.</p>

[{'answer_id': 47370, 'author': 'Mark Nold', 'author_id': 4134, 'author_profile': 'https://Stackoverflow.com/users/4134', 'pm_score': 2, 'selected': False, 'text': '<p>TOAD is a great generic tool for Oracle development and i think a similar feature is in the basic version. You can download a trial version (make sure you don\'t get the old free version of TOAD, that is about 4 years old)</p>\n\n<p>If you don\'t want to buy a tool, and you need something less flash you could roll your own quite easily. I just found <a href="http://www.codeproject.com/KB/database/OracleSchemaCompare.aspx" rel="nofollow noreferrer">Schema Compare Tool for Oracle</a> which looks very simple, and has a nice baseline concept. This is very handy if you want to track changes since the last code check-in. This way you discover changes that may have been made to multiple DBs by hand, but not documented.</p>\n\n<p><em>PS: The "SQL Compare by Red-Gate" demo looked very nice indeed... however the voice over cracked me up... sounded like a BBC documentary.</em></p>\n'}, {'answer_id': 47385, 'author': 'Matthew Watson', 'author_id': 3839, 'author_profile': 'https://Stackoverflow.com/users/3839', 'pm_score': 0, 'selected': False, 'text': '<p>There are various tools out there that you can use, I haven\'t used any of them myself though so I\'ve got no comments to make about them, but another "trick" that you can use is to create a trigger on DDL events, so you can basically capture (to a table, or log file or whatver) any changes done between deployments.</p>\n\n<p><a href="http://www.psoug.org/reference/ddl_trigger.html" rel="nofollow noreferrer">DDL Triggers</a></p>\n'}, {'answer_id': 47417, 'author': 'Doron Yaacoby', 'author_id': 3389, 'author_profile': 'https://Stackoverflow.com/users/3389', 'pm_score': 0, 'selected': False, 'text': '<p>Mark - I would like to be able to easily synchronize two database schemas. Specifically, <a href="http://www.red-gate.com/products/SQL_Compare/video_sql_compare_standard_compare_synchronize.htm" rel="nofollow noreferrer">this demo</a> looks like heaven to me.</p>\n'}, {'answer_id': 48418, 'author': 'Hobo', 'author_id': 1714, 'author_profile': 'https://Stackoverflow.com/users/1714', 'pm_score': 1, 'selected': False, 'text': '<p>Hitchhiker,</p>\n\n<p>If you\'re willing to spend some money, TOAD has "compare schemas" functionality which should do what you\'re after.  It\'ll report the differences and produce a migration script to bring one into line with the other.</p>\n\n<p>I\'ve never used the script, so I can\'t vouch for it, but I have used it to make sure our build scripts are complete.</p>\n'}, {'answer_id': 49253, 'author': 'John Smithers', 'author_id': 1069, 'author_profile': 'https://Stackoverflow.com/users/1069', 'pm_score': 2, 'selected': False, 'text': '<p><a href="http://www.dkgas.com/" rel="nofollow noreferrer">OraPowerTools</a> will do the job.<br>\nThere is also a "Diff Wizard" in <a href="http://www.oracle.com/technology/software/products/sql/index.html" rel="nofollow noreferrer">Oracle SQL Developer</a>, but I haven\'t used it yet.</p>\n'}, {'answer_id': 315956, 'author': 'FerranB', 'author_id': 40441, 'author_profile': 'https://Stackoverflow.com/users/40441', 'pm_score': 0, 'selected': False, 'text': '<p>Check out Oracle Enterprise Manager Change Management Pack, its an Oracle tool for this:</p>\n\n<p><a href="http://www.oracle.com/technology/products/oem/pdf/ds_change_pack.pdf" rel="nofollow noreferrer">http://www.oracle.com/technology/products/oem/pdf/ds_change_pack.pdf</a></p>\n\n<p>You can try it there:</p>\n\n<p><a href="http://www.oracle.com/technology/software/products/oem/index.html" rel="nofollow noreferrer">http://www.oracle.com/technology/software/products/oem/index.html</a></p>\n'}, {'answer_id': 1521408, 'author': 'David Atkinson', 'author_id': 167364, 'author_profile': 'https://Stackoverflow.com/users/167364', 'pm_score': 5, 'selected': True, 'text': '<p>Red Gate Schema Compare for Oracle has now been released!</p>\n\n<p><a href="http://www.red-gate.com/products/schema_compare_for_oracle/index.htm" rel="nofollow noreferrer">http://www.red-gate.com/products/schema_compare_for_oracle/index.htm</a></p>\n\n<p>There is a 28-day fully functional free trial. Please give it a go and let us know your feedback!</p>\n'}]
['https://Stackoverflow.com/questions/47366', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3389/']