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 <msenecal...@gmail.com> 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 :)
