Forum: Ruby on Rails Migrate Data and Schema from MySQL to sqlite

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
7595ff5e64d9a309c29932d106959973?d=identicon&s=25 Human Dunnil (Guest)
on 2007-02-17 12:39
(Received via mailing list)
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

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
140c065a9604b5321768cbe02e91ef30?d=identicon&s=25 Anton Aylward (Guest)
on 2007-02-17 15:07
(Received via mailing list)
Human Dunnil said the following on 02/17/2007 06:38 AM:
> 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
meant it was unusable.

So I searched for and found a rakefile that dumped each table to a YAML
I then used rake to relada them as fixtures.

   rake db:fixtures:load

See V

   Self-righteous crackers
      -- CSO Magazine's "The Devil's Infosec Dictionary"
This topic is locked and can not be replied to.