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 > >