<p>I am looking for something to integrate to my CI workflow.<br>
I've heard of <a href="http://dbdeploy.com" rel="noreferrer">dbdeploy</a> but I'm looking for something else. The reason I don't like dbdeploy is I don't want to install java on my server.</p>

<p>I would prefer of course that the solution doesn't involve stringing some shell scripts together.</p>

[{'answer_id': 27664, 'author': 'Iain Holder', 'author_id': 1122, 'author_profile': 'https://Stackoverflow.com/users/1122', 'pm_score': 3, 'selected': False, 'text': '<p><a href="http://www.red-gate.com/" rel="nofollow noreferrer">Redgate</a> will probably do everything you need.  Expensive though.</p>\n\n<p>EDIT - Specifically: <a href="http://www.red-gate.com/products/sql-development/readyroll/" rel="nofollow noreferrer">http://www.red-gate.com/products/sql-development/readyroll/</a></p>\n'}, {'answer_id': 27683, 'author': 'chrissie1', 'author_id': 2936, 'author_profile': 'https://Stackoverflow.com/users/2936', 'pm_score': 1, 'selected': False, 'text': '<p>Yep, Redgate is magic. And Not that expenssive for what it provides. </p>\n'}, {'answer_id': 27891, 'author': 'James A. Rosen', 'author_id': 1190, 'author_profile': 'https://Stackoverflow.com/users/1190', 'pm_score': 3, 'selected': False, 'text': '<p>It\'s not a tool, but Ambler and Sadalage\'s book, <a href="https://rads.stackoverflow.com/amzn/click/com/0321293533" rel="noreferrer" rel="nofollow noreferrer">Refactoring Databases: Evolutionary Database Design</a> is quite good.</p>\n'}, {'answer_id': 27914, 'author': 'ScottStonehouse', 'author_id': 2342, 'author_profile': 'https://Stackoverflow.com/users/2342', 'pm_score': 0, 'selected': False, 'text': "<p>Visual Studio Team system (database edition) does some refactoring.</p>\n\n<p>I read the Refactoring databases book.  I think it's helpful.</p>\n\n<p>But in software dev, you build tests so that you are safe refactoring.  They don't touch on tests in the Refactoring Databases book, which was my big disappointment with it.</p>\n"}, {'answer_id': 27936, 'author': 'ollifant', 'author_id': 2078, 'author_profile': 'https://Stackoverflow.com/users/2078', 'pm_score': 0, 'selected': False, 'text': "<p>I think those tools are very good, but for my purpose I have written a custom own. The main reason for this was because of I'm working on a SQL Server Compact 3.5 database, so none of the listed tools worked.</p>\n\n<p>Of course it isn't as powerful as the tools from Redgate but you get the most important features very quick.</p>\n\n<p>It's able to rename all kinds of database objects and migrating columns to other tables and create a diff script for 2 databases.</p>\n"}, {'answer_id': 79107, 'author': 'Saul Dolgin', 'author_id': 8305, 'author_profile': 'https://Stackoverflow.com/users/8305', 'pm_score': 2, 'selected': False, 'text': '<p>You mentioned that you like dbDeploy and the fact that you do not want to install java on your server.  Are you aware of <a href="http://sourceforge.net/projects/dbdeploy-net" rel="nofollow noreferrer">the .NET port</a> of this tool?  </p>\n\n<p>I used this recently with a team and we were very happy with it.  In our case we were targeting SQL 2000, but it could easily be configured to run against other DB platforms, including MySQL.  Of course it will require you to have the .NET Framework installed on the server... if that\'s an acceptable prerequisite vs. the java runtime.</p>\n'}, {'answer_id': 170658, 'author': 'FoxyBOA', 'author_id': 19347, 'author_profile': 'https://Stackoverflow.com/users/19347', 'pm_score': 2, 'selected': False, 'text': '<p>Possible it\'s not your case, but if you decide to use Java take a look at <a href="http://liquibase.org/" rel="nofollow noreferrer">liquibase</a></p>\n'}, {'answer_id': 3675654, 'author': 'Roman Podlinov', 'author_id': 427457, 'author_profile': 'https://Stackoverflow.com/users/427457', 'pm_score': 1, 'selected': False, 'text': '<p>Try <a href="http://www.thisisagile.com/dbrire" rel="nofollow noreferrer">Agile DBRIRE</a> for Continuous Integration workflow. It\'s easy to set and allows to generate test db from Dev DB. Also it allows to generate incremental DB updates for Staging and Production. The tool can compare DEV and Staging/Production DB and generate metadata and data update SQL scripts. The tool is free.</p>\n'}, {'answer_id': 4763403, 'author': 'Axel Fontaine', 'author_id': 350428, 'author_profile': 'https://Stackoverflow.com/users/350428', 'pm_score': 4, 'selected': False, 'text': '<p><a href="http://flywaydb.org"><strong>Here</strong></a> is a <strong>feature comparison</strong> between</p>\n\n<ul>\n<li>Flyway</li>\n<li>Liquibase</li>\n<li>c5-db-migration</li>\n<li>dbdeploy</li>\n<li>mybatis</li>\n<li>MIGRATEdb</li>\n<li>migrate4j</li>\n<li>dbmaintain</li>\n<li>AutoPatch</li>\n</ul>\n'}, {'answer_id': 5354567, 'author': 'Erwin van Brandwijk', 'author_id': 666311, 'author_profile': 'https://Stackoverflow.com/users/666311', 'pm_score': 2, 'selected': False, 'text': '<p>for those people who are interested in liquibase, but don’t like xml migrations.\nTake a look at <a href="https://github.com/tlberglund/groovy-liquibase" rel="nofollow">groovy-liquibase</a>, a plugin that supports groovy migrations</p>\n\n<p>Liquibase is great in structure, but misses with xml migrations. This plugin solves that problem</p>\n'}, {'answer_id': 41045828, 'author': '8DH', 'author_id': 381993, 'author_profile': 'https://Stackoverflow.com/users/381993', 'pm_score': 0, 'selected': False, 'text': '<p>An important part of <a href="https://rads.stackoverflow.com/amzn/click/0321293533" rel="nofollow noreferrer" title="Refactoring Databases">Refactoring Databases</a> is the migrations part.\nA .NET migrations solution that does not require EF or Java is Rob Reynold\'s <a href="https://github.com/chucknorris/roundhouse" rel="nofollow noreferrer" title="Roundhouse">Roundhouse</a></p>\n\n<p>Might be worth checking out.</p>\n'}]
['https://Stackoverflow.com/questions/27663', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2976/']