Hello folks, I have a client who needs his data on a multimedia CD-ROM. I''ve used MySQL as a database for his web application. Now, I need to migrate his data on regular basis to sqlite so I can use the new db on the CD-ROM. What do you guys recommend me to do? Should I write a script which READ data from mysql (using ActiveRecords for example) and INSERT them in the new sqlite? Is there any other solutions? And I must write a tool or script to run on MS Windows. :( Thanks in advance, - Dunnil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Human Dunnil said the following on 02/17/2007 06:38 AM:> > I have a client who needs his data on a multimedia CD-ROM. I''ve used > MySQL as a database for his web application. Now, I need to migrate > his data on regular basis to sqlite so I can use the new db on the > CD-ROM. > > What do you guys recommend me to do? Should I write a script which > READ data from mysql (using ActiveRecords for example) and INSERT them > in the new sqlite? Is there any other solutions? > > And I must write a tool or script to run on MS Windows. :(I was faced with a similar problem. I''d developed on my laptop (32 bit Intel) but the server to be deployed was 64 bit. Tarz''ing up the SQLite database on the one and untarz''ing it on the other meant it was unusable. So I searched for and found a rakefile that dumped each table to a YAML file. I then used rake to relada them as fixtures. rake db:fixtures:load See Vhttp://snippets.dzone.com/posts/show/3393 -- Hackers: Self-righteous crackers -- CSO Magazine''s "The Devil''s Infosec Dictionary" --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---