<div dir="ltr">I've had success in the past between SQLite and Postgres using rake db:data:[dump|load]_dir, was a production database with some good 300k records on it.<div><br></div><div><a href="http://stackoverflow.com/questions/7257647/using-rake-to-dump-and-load-database">http://stackoverflow.com/questions/7257647/using-rake-to-dump-and-load-database</a><br>
</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 4, 2014 at 12:58 PM, Riccardo Tacconi <span dir="ltr"><<a href="mailto:rtacconi@gmail.com" target="_blank">rtacconi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Do you need to migrate only table's schema and data? If yes: <a href="https://github.com/ricardochimal/taps" target="_blank">https://github.com/ricardochimal/taps</a></div>
<div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">
On 4 March 2014 11:32, Frederick Cheung <span dir="ltr"><<a href="mailto:frederick.cheung@gmail.com" target="_blank">frederick.cheung@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

I've been curious about <a href="https://code.google.com/p/tungsten-replicator/" target="_blank">https://code.google.com/p/tungsten-replicator/</a> but have never reached the point where I can justify the effort involved in battle testing it.<br>


<br>
Among other things you can stream your mysqlbinlog into postgres which should make for a smaller amount of downtime.<br>
<br>
Fred<br>
<div><div>On 4 March 2014 at 11:12:08, Andrew Stewart (<a href="mailto:boss@airbladesoftware.com" target="_blank">boss@airbladesoftware.com</a>) wrote:<br>
><br>
> Hello LRUG,<br>
><br>
> What's the current best way to migrate data from MySQL to Postgres?<br>
> Everything I've found seems to be somewhat, er, "beta".<br>
><br>
> Thanks in advance,<br>
><br>
> Andy Stewart<br>
><br>
> _______________________________________________<br>
> Chat mailing list<br>
> <a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br>
> <a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
><br>
<br>
_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br>Riccardo Tacconi<br>Ruby on Rails and PHP development - System Administration<br><a href="http://www.virtuelogic.net/" target="_blank">VIRTUELOGIC LIMITED</a><br>

<br><a href="http://github.com/rtacconi" target="_blank">http://github.com/rtacconi</a><br><a href="http://riccardotacconi.blogspot.com" target="_blank">http://riccardotacconi.blogspot.com</a><br><a href="http://twitter.com/rtacconi" target="_blank">http://twitter.com/rtacconi</a>
</font></span></div>
<br>_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
<br></blockquote></div><br></div>