ok, that's sounds like a good idea (btw - dal is worth gold!) Thanks for the help Massimo! :)
On May 18, 4:43 pm, Massimo Di Pierro <[email protected]> wrote: > If you know the mssql table structure, you can create a quick web2py > model: > > db=DAL('mssql://...') > db.define_table('yourtable',Field(...),....) > print str(db(db.yourtable).select()) # outputs the CSV > > On May 18, 3:32 pm, mart <[email protected]> wrote: > > > > > > > > > Hi, > > > there's this MSSQL server running remotely, and I would like to access > > it with DAL. So I'm thinking, i should export to CSV then import using > > dal.py in something local (like SQLite). Here's the problem... I don't > > know how to dump the MSSQL tables to CSV :( > > > This is a 2005 MS SQL install. Would anyone have a trick? is there > > some sort of tool/option/something i can use to say 'dump all tables > > to csv' ? > > > I assume, them i can simply point top those CSV file and import? > > > Thanks for the help, > > Mart :)
