<div>
<br />
Actually, if the your DB2 is on AS/400, then you can use a linked server in SQL Server, too. <br />
<br />
I haven't done this in a few years, but you can create a DTS package to automatically send data to and from your disparate data sources.<br />
<br />
HTH,<br />
DaveSlash<br />

</div>



Actually, if the your DB2 is on AS/400, then you can use a linked server in SQL Server, too.

I haven't done this in a few years, but you can create a DTS package to automatically send data to and from your disparate data sources.

HTH,
DaveSlash


<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
I want to ask about how can I replicate data from non-DB2 database (Specificly , Microsoft SQL Server 2007) to IBM DB2 version 8. please I want a very detailed description for that because I have no experince in DB2 at all !
</div>
</div>


Dear All,

I want to ask about how can I replicate data from non-DB2 database (Specificly , Microsoft SQL Server 2007) to IBM DB2 version 8. please I want a very detailed description for that because I have no experince in DB2 at all !

DB2 Replication from Microsoft SQL Server

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.