Hello Kristian
[header snipped]
> trying to move a bigger amount of data to my shiny new MaxDB-based
> production system, I am now facing the challenge of exporting
> data from
> MSSQL97 to MaxDB. Which doesn't work at the moment, no matter
> what I do:
>
> * Tried to follow the "obvious" way of creating two ODBC data sources
> (MSSQL, MaxDB) and use the MSSQL DTS Tool to copy from the
> first to the
> second one. This fails: Obviously, the SQL issued by the exporter
> creates case-sensitive table and row names within MaxDB, but
> the part of
> the SQL exporter that will actually export data doesn't honour this.
> Example: Table "Foo" (inside MSSQL) is created as table "Foo"
> in MaxDB,
> but, while copying data, the MaxDB ODBC driver complains that table
> "FOO" is not found - if I get that right, it's a matter of '' vs. "" -
> quoting in SQL?
The problem might be, that MaxDB needs quotes (") in order to process
identifier as case-sensitive. Although, this could be handled by the DTS-tool,
since all this stuff can be collected from the drivers (SQLGetInfo). But as
usual, MS-tools are much better in importing than in exporting.
Writing tables to a file and importing with the loader might be a solution for
you. On the other hand, a home brewed tool (i.e. no sophistcated error handling
etc) might be not so complicated using JDBC or ODBC.
Regards Thomas
----------------------------------------------
Dr. Thomas Kötter
SAP AG, Berlin
NW DT MaxDB
MaxDB: all you need!
www.mysql.com/products/maxdb www.sapdb.org
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
