Or you can try it the long, round about way - http://www.realpython.com/blog/python/web2py-migrating-from-sqlite-to-mysql/#.Ulm3xmTTXCU
On Friday, October 11, 2013 6:14:43 PM UTC-6, François Delpierre wrote: > > Hi, > > For performance reason I would like to migrate my DB from sqlite to > postgreSQL DB. > What's the best way to do it. > I spent some time with the export > / db.import_from_csv_file(open('somefile.csv', 'rb')) and I just feel like > I'm loosing my time for 2 hours. > After trying to fix various problems, now I notice that all my keys are > wrong, so the db.import_from_csv does not keep the id values, and so > completely break the application. > > What is the recommended way to migrate from sqlite to an other DB (without > breaking the application)? > > Thanks, > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.