Post reply

incremental replication

  • August 4, 2006 at 1:42 am

    #94173

     I have copied a  database from an AS400 machine into SQL and now am developing an application on the SQL.    The initial database on AS400 DB2 V5R1 keeps on updating.    how can do incremental replication  on the new updates  and keep my SQL in sync with old one.

  • August 8, 2006 at 3:03 am

    #653783

    You don't give many details.  Have a read about merge replication and transactional replication with updating subscriptions and see if either of those meets your needs.

    John

  • August 9, 2006 at 8:31 am

    #654088

    How big is the table ?  If it's small, maybe it would be easier to DTS the AS/400 table every night into your SQL table and replace the data. I can't imagine any way to truly replicate from the AS/400 to SQL, but I've been off the As/400 for a few years, so there may be new features I don't know about. If you HAVE to do some kind of "replication" from the AS/400 to SQL, you might be able to rig something up by reading the AS/400 journals (equivalent to SQL Trans logs) and put those journals into a temp SQL table file that then gets replicated to the real SQL table.  

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply