Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Unanswered: pull & push data from sql server

    Hi,

    my current applications are present in SQL server (and will continue to do so) whereas i am developing a new application using db2.....it so happens that i want to get data into DB2 from SQL (say after a select where clause) ......how can i do that????

    And if i want to insert data back into SQL server is that possible too??? If yes how???

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I think what you want is called Heterogenious Replication. You will need to look in the DB2 Reference manuals on how to set this up for you specific application.

    Andy

  3. #3
    Join Date
    May 2006
    Posts
    82
    As per my knowledge, if you want to communicate from DB2 to SQL server you may have to use IBM Data Joiners.
    Vinay,

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    in v8 it is called DB2 Information integrator or Websphere information integrator
    in V9 it is called Websphere federation server
    both with relational and non-relational wrappers
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Jul 2005
    Posts
    103
    On the SQL Server side, you could set up a Linked Server to the DB2 database. This Linked Server can be used to select data from the DB2 database and insert/update data to the DB2 database. The IBM DB2 Runtime Client would need to be installed on the SQL Server box of course.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I guess it is going to be much easier (and probably cost effective) to set up replication (near real-time data copy) from the SQL Server side ...

    If you want to do data copy at scheduled intervals, DTS may prove useful

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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