Hi all, Is there any gem to copy data from mysql to postgres ? I search lot but i didn't get any thing . Thanks Fahim
on 2013-01-14 13:07
on 2013-01-14 13:14
On Mon, Jan 14, 2013 at 6:06 AM, Fahim Patel <email@example.com> wrote: > Is there any gem to copy data from mysql to postgres ? > I search lot but i didn't get any thing . You're gonna have to figure that one out yourself by using 2 models and some clever trickery, or you might be able to dump the data and import into postgres if it's generic enough with little effort but I would much rather go the 2 model route even if it takes far more time.
on 2013-01-14 13:23
Thanks lot for reply. Few months ago i have studied about one gem which do this work, but i forget the name. Did any one know about this ?
on 2013-01-14 13:40
On 14 January 2013 12:06, Fahim Patel <firstname.lastname@example.org> wrote: > > Hi all, > > Is there any gem to copy data from mysql to postgres ? > I search lot but i didn't get any thing . http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL describes how to do a dump from mysql and restore to postgres but I don't see any advantage of using a gem over that technique. Colin
on 2013-01-14 13:51
use gem taps 2013/1/14 Colin Law <email@example.com> > > > -- Rodrigo Mendona (62) 8567-3142
on 2013-01-14 14:21
Thanks lot for reply. Fahim
on 2013-01-14 16:23
I really like yaml_db for this. I have only used it for SQLite to MySQL and MySQL to MySQL, but it works smoothly and quickly, and in my case, did not flinch at 2M records in a table. Walter
on 2013-01-15 10:19
I would like to add: if you have some custom mapping between the models, you could write a simple rake task. Example: http://myutil.com/2008/8/31/rake-task-transfer-rai... Regards, Anton