DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001


    hi all,
    i wanted to know how to syncronize the data from oracle 8/8i to mssql server 7.0 ...
    the problem here is each and every dml activity(insert,update,delete )should be replicated to mssql server tables.
    and mssql server dml activity should be replicated to oracle tables.
    at certain time interval automatically.
    right now i am thinking to capture the data in xml file and push the data to other database...
    if there is any logic which will solve the problem very easily..any related website please tell me....

    thanks in advance

  2. #2
    Join Date
    Sep 2000

    I think you could user MYSQLDMP feature as well to capture
    the required data (mysqldmp generates INSERT statements)
    and run this script file to load into Oracle. You could automate this process using CRONTAB.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.