Hi all; 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? * Also checked out several (free, non-free) tools to do the job, but those which would suffice only work with current versions of MSSQL; seems our installation is too old for that. So: ideas anyone? I have to admit I'm a little clueless at the moment, how do you handle things like that? I don't know whether hand-crafting a tool to use JDBC pulling data from MSSQL to MaxDB is worth the effort... Thanks in advance and bye, Kris -- Kristian Rink -- Programmierung/Systembetreuung planConnect GmbH * Strehlener Str. 12 - 14 * 01069 Dresden Tel. 0351 4657716 * Fax 0351 4657707 * [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
