Java/JDBC for dumping MS SqlServer rows to a text file ?

Dear all,

we are confronting ourselves with the daunting task of migrating some SqlServer tables into an Oracle 8.1.7 database; most of them are tiny tables but at least one of them is about 3,500,000 rows in size, about 1.5K for each row.

We must migrate just the data; the definition of the tables has been already migrated, together with the stored procedures (that have been completely rewritten, since of course Oracle and SqlServer are so different, that a "mechanic" translation is neither possible nor desirable).

Our task is complicated by us being located in Italy, where accented, non-ASCII characters are the norm. Our database has been of course already prepared with the correct character sets, and so on.

We have evaluated different options (using the routines in sqlserver for direct migration; using the same routines for producing an intermediate dump file to be loaded by sql*loader; using oracle migration workbench; using the Oracle transparent gateways).

Now, we are evaluating the possibility to write a small (trivial) Java/JDBC program to dump the SqlServer tables in a format easily recognizable by sql*loader (perhaps comma-separated columns, using an appropriate character set representation - probably UTF8).

We would like to know whether anyone knows if an open-source, free Java/JDBC program is available that makes something similar. We need an open-source program because we need to address some low-level issues about the format of the data, and we would like to address them *before* dumping the data to the file. We need a free program for the simple reason that we can't buy anything, even if it costs less than $1, due to management decision (not a clever decision, but I can't do anything about it).

As usual, many thanks to anyone that will answer our question, and many thanks also to anyone that has read so far.

Kind Regards
Alberto Dell'Era Received on Fri Jan 17 2003 - 05:24:59 CST