MSSQL is case-sensitive, and wants to see queries to INFORMATION_SCHEMA in
UPPER CASE.
See mssql.py.uppercase_table() for the gory details, or rather, THE GORY
DETAILS ;-)
On 7/27/07, Christophe de VIENNE <[EMAIL PROTECTED]> wrote:
>
>
> Hi svil,
>
> Still no luck. I don't know if the information
Hi,
>Still no luck. I don't know if the information_schema module is
>supposed to work well with pymssql. Anyway :
>
>
It works ok on Windows. Have a go at trying an information_schema query
directly in PyMSSQL, without using SA at all. That should settle the matter.
Paul
--~--~-~--~
Hi svil,
Still no luck. I don't know if the information_schema module is
supposed to work well with pymssql. Anyway :
Traceback (most recent call last):
File "autoload.py", line 233, in ?
autoloader = AutoLoader( engine)
File "autoload.py", line 100, in __init__
me.table_names = engi
On Friday 27 July 2007 12:44:49 Christophe de VIENNE wrote:
> 2007/7/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
> > noone wanting to try autoload'ing nor metadatadiff? i am
> > surprised.. Christophe, u can at least try how much autoload.py
> > works like your autocode2 - i got lost with 'schema'
2007/7/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
> noone wanting to try autoload'ing nor metadatadiff? i am surprised..
> Christophe, u can at least try how much autoload.py works like your
> autocode2 - i got lost with 'schema' vs 'dbname' - and/or add mysql
> support (;-)
I tried to run it on
noone wanting to try autoload'ing nor metadatadiff? i am surprised..
Christophe, u can at least try how much autoload.py works like your
autocode2 - i got lost with 'schema' vs 'dbname' - and/or add mysql
support (;-)
http://dbcook.svn.sourceforge.net/viewvc/*checkout*/dbcook/trunk/autoload.py
On Thursday 26 July 2007 11:37:08 Marco Mariani wrote:
> [EMAIL PROTECTED] ha scritto:
> > here some theory on comparing data trees, in order to produce the
> > changeset edit scripts.
> > http://www.pri.univie.ac.at/Publications/2005/Eder_DAWAK2005_A_Tr
> >ee_Comparison_Approach_to_Detect.pdf
>
>
[EMAIL PROTECTED] ha scritto:
> here some theory on comparing data trees, in order to produce the
> changeset edit scripts.
> http://www.pri.univie.ac.at/Publications/2005/Eder_DAWAK2005_A_Tree_Comparison_Approach_to_Detect.pdf
>
The complete title of the paper is "A Tree Comparison Approach
okay. first cut of metadatadiff:
http://dbcook.svn.sourceforge.net/viewvc/*checkout*/dbcook/trunk/metadatadiff.py
... test changes:
class Address( o2r.Base):
size = Text() #change type
place = Text2() #change type-details
class Employee( o2r.Base): #inhe
here some theory on comparing data trees, in order to produce the
changeset edit scripts.
http://www.pri.univie.ac.at/Publications/2005/Eder_DAWAK2005_A_Tree_Comparison_Approach_to_Detect.pdf
of course full automation is not possible and not needed - but why not
do maximum effect/help with mini
another version, separated autoload from code-generation,
which is now the __main__ test.
http://dbcook.svn.sourceforge.net/viewvc/*checkout*/dbcook/trunk/autoload.py
now it is possible to do something like:
$ python autoload.py postgres://[EMAIL PROTECTED]/db1 | python - sqlite:///db2
copyin
11 matches
Mail list logo