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 sits on a remote server,
and I am connected through VPN (although this shouldn't make a
difference)
then made the connection to look like this (not sure if I need the
port number - but fails with or without):
db = DAL("mssql://sa:passw...@build-control:1433/quickbuild")
Thanks again and any suggestion will be much appreciated :)
Mart
On Nov 14, 12:19 pm, mdipierro <[email protected]> wrote:
> 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 <[email protected]> wrote:
>
> > 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 <[email protected]> wrote:
>
> > > 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 <[email protected]> wrote:
>
> > > > 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 <[email protected]> wrote:
>
> > > > > Hi,
>
> > > > > So, application "build system" uses SQLite for most current and future
> > > > > software builds. But would also like the application to connect to an
> > > > > MSSQL which which hosts legacy software builds. The legacy builds will
> > > > > continue to be used and even updated for some time, so daily updates
> > > > > would need to be caught as well. SO, the requirement is to build the
> > > > > older builds with the new build systems, but without changing anything
> > > > > on the older legacy side.
>
> > > > > Suggestions? Would I be able with web2py to do some context switching?
> > > > > I.e query MSSQL DB, grab some data, then store that in the newly
> > > > > generated tables of an SQLite db, then begin as normal.
>
> > > > > Or, i'm thinking it would be better to replicate/convert the MSSQL DB
> > > > > to SQLite (with daily updates) Would the DAL support that kind of
> > > > > activity ? The optimal scenario is that the the build system owns that
> > > > > activity which use the DAL with web2py ad also as Stand ALone
>
> > > > > Again, any help or direction would be much appreciated.
>
> > > > > Thanks
> > > > > Mart :)
>
>
