[LRUG] MySQL to Postgres

[Alex Reis]

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.

http://stackoverflow.com/questions/7257647/using-rake-to-dump-and-load-database




On Tue, Mar 4, 2014 at 12:58 PM, Riccardo Tacconi <rtacconi at gmail.com>wrote:

> Do you need to migrate only table's schema and data? If yes:
> https://github.com/ricardochimal/taps
>
>
> On 4 March 2014 11:32, Frederick Cheung <frederick.cheung at gmail.com>wrote:
>
>> I've been curious about https://code.google.com/p/tungsten-replicator/but have never reached the point where I can justify the effort involved in
>> battle testing it.
>>
>> Among other things you can stream your mysqlbinlog into postgres which
>> should make for a smaller amount of downtime.
>>
>> Fred
>> On 4 March 2014 at 11:12:08, Andrew Stewart (boss at airbladesoftware.com)
>> wrote:
>> >
>> > Hello LRUG,
>> >
>> > What's the current best way to migrate data from MySQL to Postgres?
>> > Everything I've found seems to be somewhat, er, "beta".
>> >
>> > Thanks in advance,
>> >
>> > Andy Stewart
>> >
>> > _______________________________________________
>> > Chat mailing list
>> > Chat at lists.lrug.org
>> > http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>> >
>>
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
>
>
>
> --
> Riccardo Tacconi
> Ruby on Rails and PHP development - System Administration
> VIRTUELOGIC LIMITED <http://www.virtuelogic.net/>
>
> http://github.com/rtacconi
> http://riccardotacconi.blogspot.com
> http://twitter.com/rtacconi
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20140304/c9aae588/attachment-0003.html>