seems to work, but I still couldn't make it work on my project (worked well on smaller projects though)
2012/3/27 Anthony <abasta...@gmail.com> > http://web2py.com/books/default/chapter/29/6#CSV-(all-tables-at-once) > > > On Tuesday, March 27, 2012 11:26:17 AM UTC-4, Marco Tulio wrote: >> >> Hi! >> >> I was using sqlite as my database for a few projects, but decided to go >> to postgres. >> >> While to web2py going from one to another is pretty much a connection >> string that you'll change, there's still one problem remaining. >> >> How do I get the data that was on my app (on the sqlite database). >> >> On a small application, I managed to do that by exporting a csv file on >> the old app and importing it on the new one. And that's it. >> >> But I have another app that has quite a few tables now... wich means that >> I'd have to copy several cvs and import them. >> >> Question is: isn't there an easier way to do it? (to backup a sqlite >> database and restore it as postgres in one piece?) >> >> If there isn't, that means that worst case scenario, I'll have to >> export/import csv's corresponding to my tables. I can do that... >> but there really isn't another way ? >> >> Thanks! >> -- >> []'s >> Marco Tulio >> >> -- []'s Marco Tulio