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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
