I've done it a couple ways, it's been a while however.
The version of SQL server I worked with perhaps 6-7 years ago had an addon
called DTS that would allow configuration of and connection to an ODBC
data source. We had two way updates running on a scheduled basis using
DTS. These updates were scheduled off hours so performance wasn't a
concern.
Another way was using JDBC, that was just in test mode so no idea what
performance would have been like in a production environment.
Bob
From:
gregg.eldred@xxxxxxxxxxx
To:
domino400@xxxxxxxxxxxx
Date:
02/05/2009 11:40 PM
Subject:
SQL and DB2
Sent by:
domino400-bounces+rlaing=gemko.com@xxxxxxxxxxxx
I realize that this probably isn't the right place to post this, so I am
hoping that someone can point me to the appropriate site/TechNote/etc.
We'd like to connect SQL Server and DB2 (on the iSeries). What is the best
way to move data between the two (ODBC, something else), especially when
looking at performance?
Thanks.
Gregg
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/domino400.
midrange.com
