Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-06-20 : 03:44:37
|
| hi,i need to transfer table (full and incremental) from DB2 to SQL SERVER (SQL 2008 R2 -St.Edition -32 bit)i found the only way to do it is by linke server.(we can't use ole db for db2 because it can use only on Ent.Edition)do you haveany suggestion?? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-20 : 07:50:39
|
| IBM provides an OLE DB driver that you can install and use for a linked server. I don't have a link for it but it will be included in the client tools for AS/400 connectivity. If you're running DB2 on another platform the driver should be available on IBM's website. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-06-20 : 08:32:56
|
| i know,i install iseries .and create odbc on this driver.but is that way to pull data with linked server? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-20 : 08:50:28
|
Its a way  We do it that way to have full control of the process.SELECT *INTO ##TEMPFROM OPENQUERY(MyLinkedServer, 'SELECT * FROM RemoteTable WHERE MyChangeDate > ''20100620'') and then we Update-existing/Insert-new rows locally |
|
|
|
impichit
Starting Member
2 Posts |
Posted - 2010-07-18 : 19:31:12
|
| I use IBM provides an OLE DB driver and SQL OLE DB/SQL Native by SSIS it veryfastmy problem for LinkServer if you have many record in db2 it very slow to transfer |
|
|
|
|
|
|
transfer table from DB2 to SQL