great! was going through the book and had just spotted something
looking like that:) thanks :)
One issue though:
have been trying to connect to the remote mssql db for a while, and
not really getting anywhere :( any tips and tricks with that one?
I'm on MAC OS, 10.6
installed pyodbc
the MSSQL db
connect to mssql
db.export_to_csv_file(file)
change uri to connect to sqlite
db.import_from_csv_file(file)
Should work
On Nov 14, 8:54 am, mart wrote:
> I guess another question, is ... does the DAL support migrating the
> MSSQL DB (MS SQL server 2005) to SQLite?
>
> Thanks
> Mart :)
>
>
I guess another question, is ... does the DAL support migrating the
MSSQL DB (MS SQL server 2005) to SQLite?
Thanks
Mart :)
On Nov 14, 9:37 am, mart wrote:
> sounds easy enough then :) I think I equated something I configured
> wrong to something not supported. SO, will do the second connection
sounds easy enough then :) I think I equated something I configured
wrong to something not supported. SO, will do the second connection as
you suggest.
Thanks for the reply :)
Mart
On Nov 14, 6:28 am, Nico de Groot wrote:
> Hi Mart,
>
> No problem, you can define a second connection, say db_ms,
Hi Mart,
No problem, you can define a second connection, say db_ms, that
connects to your ms sql database. And then query and insert across
databases.
Nico
On 14 nov, 07:30, mart wrote:
> Hi,
>
> So, application "build system" uses SQLite for most current and future
> software builds. But woul
5 matches
Mail list logo