DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to synchronise the data from oracle to mssql server

  1. #1
    Join Date
    Feb 2001
    Posts
    1

    Smile

    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
    sateesh


  2. #2
    Join Date
    Sep 2000
    Posts
    155

    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