> I'm trying to migrate a lot of data from an accounting
> system software to another using Python.
he easiest way to do this is usually to create a set of
views using SQL in one database that map to the schema
in the other. You can then read the table data out of
the views and export it into
Negroup - wrote:
> Anyway, I'm learning Python and just for exercise I'll try to
> implement a simple sql-like interface for querying dictionaries!
It might be a better use of your time to learn about Python's built-in
abilities to manipulate lists and dictionaries, which are powerful and simple.
2005/7/13, Sandip Bhattacharya <[EMAIL PROTECTED]>:
> Negroup - wrote:
[cut]
>
> Why dont you use python-sqlite to dump your data? You might need to
> modify your sql slightly(depending on your current db), but rest is all sql.
Thanks for the suggestion, I didn't even know about python-sqlite
exi
Negroup - wrote:
> Hi all, I hope my questions makes sense..
> I'm trying to migrate a lot of data from an accounting system software
> to another using Python. Software A stores datas inside sql tables,
> software B too, with a different db structure.
>
> My idea has been to export sensible table
Hi all, I hope my questions makes sense..
I'm trying to migrate a lot of data from an accounting system software
to another using Python. Software A stores datas inside sql tables,
software B too, with a different db structure.
My idea has been to export sensible tables from db A, store them in
py
