Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: Replication of DB2 data on SQL Server

    What tools are available to update SQL Server application tables from a DB2 database?

    The DB2 database is on iSeries (AS/400).

    Thanks in advance.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    you can probably create a linked server from SQL Server to DB2 and then use select statements as usual. search for db2 on the link below.

    http://msdn2.microsoft.com/en-us/library/ms190479.aspx

  3. #3
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    It really depends on the version of SQL Server you are running. Linked servers as mentioned is one option, another option is using DTS or SSIS to transfer data regulary. Unfortunately it appears that you have to pull the data from the SQL Server, I don't think the AS/400 will be able to push data to the SQL Server.

  4. #4
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    You could write java programs to push data either way using an JDBC connectivity.

    We can also look @ tools from IBM to push data to SQL Server using DB2 Information Integrator V8, IBM DB2 Replication & DataPropagator.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •