Lyn Duong wrote:
Hi all
I'm trying to transfer data from sqlserver 2000 to ibm db2 AIX 8.1.4
using dts packages
This works when I use db2 ole db drivers but the problem is that the
transfer is very slow as the rows are committed 1 by 1. I want to use
th odbc driver but it doesn't seem to work.
Has anyone experienced this? any ideas to speed up the transfer or
use odbc driver instead of ole db ?
Thanks
Lyn
Lyn,
As a wildcard option...
You **could** try using FreeTDS, (
www.freetds.org ) and see if it will
compile on AIX. I've never tried it, but it might compile on AIX. Of
course you have to have a c-compiler on the system, and a few other
goodies to compile it. FreeTDS is the use of the Sybase Tabular Data
Stream library, which is typically used in Linux environments to get
data from a SQL-Server system. We have all manner of scripts running
on our Linux boxes connected with FreeTDS to our SQL-Server systems to
pull data. FreeTDS is the Sybase netlib library, so will be faster than
ODBC, but again, much depends on your ability to get FreeTDS to compile
on AIX--there may be a precompiled binary out there somewhere you can
use too. Chances are you won't be able to compile it on AIX, but you
**could** set up a Linux box, pull the data over with freebcp, which
comes with freetds, and then mount the drive with the data on AIX, and
load it. FreeTDS takes about 5 minutes to install from scratch, and
the config file looks a lot like an INI file, which also takes about
5 minutes to configure.
There is also jTDS at
http://jtds.sourceforge.net/ . Again, much
depends on whether or not you can get this installed in your
environment. It might be more of an option than FreeTDS as it is
supposed to be platform independent.