Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    18

    Question Unanswered: Continuously synchronizing SQL Server data to DB2

    I want to synchronize data on SQL Server to DB2 at regular intervals. I want to use DB2 database for reporting and later use any BI tool.

    Is there any free tool to synchronize the data?

  2. #2
    Join Date
    Jul 2004
    Posts
    306
    What versions, operating systems (all on windows?)?
    How complex is the host DB?

  3. #3
    Join Date
    Feb 2005
    Posts
    18
    The host is not complex enough. There are three main tables and the other tables act as temporary tables.

    I am using DB2 Express-C 9.7 and OS is Windows Server 2008 R2.

  4. #4
    Join Date
    Jul 2004
    Posts
    306
    How often do you need them synchronized?
    I doubt there are any free replication tools to do this and your version of DB2 doesn't give you any tools that could help..

    Can you not do this with DTS in SQL Server?
    Failing that if it's a once a day sync and it doesn't need to be too flash I guess you could batch up an export import job...

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I would recommend using SQL Server's Transactional Replication for this job. This is exactly what it is made for, continuous replication as transactions are committed.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    It depends what you mean by regular intervals. If you mean regular scheduled intervals try SSIS - I export\import data from DB2 to SQL server without a problem.

Tags for this Thread

Posting Permissions

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