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 |
|
duncanpts
Starting Member
11 Posts |
 Posted - 2013-04-24 : 02:15:50
|
| Hi,can we replication from DB2 to MSSQL2012?Thanks,Duncan |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-04-24 : 07:14:47
|
| Probably start here: http://msdn.microsoft.com/en-us/library/aa744749%28v=bts.10%29.aspxIt's an old article and I've never used it myself. In the past I've copied DB2 data via linked servers and using the iSeries import/export utility. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-25 : 01:00:13
|
| Same here, never done it. But...DTS and DTSX (SSIS) work great for this using the iSeries ODBC provider (better than the MS provider usually). I imagine that following the replicaThe article Rob referenced talks about MS supporting longer names and this isn't an issue if pulling from DB2.Definitely take a look at the links at the bottom of the article depending on your DB2 platform. |
|
|
|
|
|
|
replication from DB2 to MSSQL2012