Hi JP, I haven't tried migrating between databases before, but I took a quick look at the link you provided. The basic concept, of using SQLAlchemy's support for each database to read and write a table at a time with separate connections and sessions, seems reasonable as long as your table contents are on the smaller side.
Before anything else, I recommend going through the tutorial (http://docs.sqlalchemy.org/en/rel_0_7/orm/tutorial.html) and verifying that your arguments to create_engine() allow you to query data from your sqlite database to be migrated and create tables and add rows to the mysql database you wish to migrate to. After that, if you still have issues migrating, try to let us know as much as possible about what happened. What parts of the process didn't work? Did you get any error messages? All the best, Chris On Saturday, December 8, 2012 8:41:23 PM UTC-5, junepeach wrote: > > I am looking for an efficient way to migrate all of the data in sqlite DB > to mysql DB using sqlalchemy. Does anybody here know about it. I really > appreciate if you can post your testing code in this forum. I searched > online and found this link: > http://www.tylerlesmann.com/2009/apr/27/copying-databases-across-platforms-sqlalchemy/, > however I don't know why it didn't work for me. I am sure there are some > other languages which can do a nice job too, but I would like to use > sqlalchemy which I am very interested in learning. > > Thanks a lot and best regards! > > JP > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/Z_NRrFdd9m0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
