Hi Thomas; @list...
Koetter, Thomas Theodor schrieb:
>
>
> 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.
Indeed, that's what I found out, as well... :/
> 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.
That was my initial idea, right. But, after an afternoon of messing
around with the DTS exporter as well as the sqlcli interface, I found a
way that works well (though it is ugly, but since database migration
isn't something you do each day, it's probably okay). Base idea:
* Use the MSSQL Enterprise Manager to generate SQL CREATE scripts for
each table in the database
* Run these scripts through Unix-sed to make the SQL they contain usable
for MaxDB
* Feed these scripts into sqlcli and see all tables generated with the
appropriate names.
* Use MSSQL enterprise Manager to export data to the MaxDB database
(which will result in each table being generated again using a
case-sensitive name, but those will not be used since DTS export will
insert into the tables generated manually before using case-insensitive
names)
* Use a bunch of scripts to manually delete the tables generated by
MSSQL DTS export (those with mixed upper/lowercase names only).
After building a couple of bash scripts to merely run steps (1) to (3)
and (5) automatically, things work, even if it's ugly. Perhaps I'll try
it in JDBC later. Btw is there any sort of tool for MaxDB (available,
planned) to do this sort of export? Shouldn't be too hard getting
something like this started in a more or less "generic" approach (i.e.
"any-to-MaxDB" - import with the ability of loading JDBC drivers for a
certain DBMS to export from)...
Cheers & thanks,
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]
