Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I need help with a MySQL database. We develop a big SaaS system on .net and we have 2 db servers:

  • Local for developers, they make changes on this etc. This server is in other city where all team are.
  • QA environment database server - this is used for QA of this solution.

We need to make auto sync between this two databases. When Cruise Control.NET deploy new version to QA environment we should get latest database structure from Local server to QA server.

Requirement is to have free software for doing this and it should be Windows.

share

locked by HopelessN00b Jan 26 at 6:38

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as off-topic by HopelessN00b Jan 26 at 0:37

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

If free software is what you need, then might as well write your own pl/sql to handle majority of the work. I suggest setting up replication between your Dev and QA server. Here is a link on how to set up replication on MySQL server: http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

If there are specific things you want to happen, such as data manipulation and such and need more than replication. Try setting up triggers Such as On Update or On Delete or On Insert, and do this or that. You can even invoke java cli from MySQL to do more than SQL operation. But if you are willing to spend a few hundred bucks, I recommend Navicat, which has a sync tool. And you can set up a customize sync to be executed.

share

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.4.24.2525\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Server Fault works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </noscr"], "copyright__copyright__copyright": ["ings you want to happen, such as data manipulation and such and need more than replication. Try setting up triggers Such as On Update or On Delete or On Insert, and do this or that. You can even invoke java cli from MySQL to do more than SQL operation. But if you are willing to spend a few hundred bucks, I recommend Navicat, which has a sync tool. And you can set up a customize sync to be executed.\n\nshare\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}