synchronizing data updates between Oracle and SQL server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: synchronizing data updates between Oracle and SQL server

  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Question synchronizing data updates between Oracle and SQL server

    Hi!
    I am dusty,,,
    I think I might have an unique query..

    1, Can we synchronize data updates between Oracle and SQL server- parallel?
    Updates at the same time and must reflect at both the DB's..
    If so how to do it ...is there a tool for it or should it be done in the front end coding.. My client has his data’s on both the DB's

    2, Is there a way to access SQL server through oracle table level triggers and vice versa? as far As I know it cannot be done ....is there anyone who can answer the same

    This is needed very urgently
    Dusty

  2. #2
    Join Date
    Aug 2002
    Posts
    115
    Its possible to connect to oracle db and make changes from sql server through linked server.

  3. #3
    Join Date
    Jan 2004
    Posts
    14

    Angry I know that

    I know the connectivity from sql server to oracle .. I want reverse compatibilty

  4. #4
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    hello

    u need to go for heterogenous connectivity option.

    you can connect to sql server using the above connectivity.

    check out for the documentation...

    http://otn.oracle.com/products/oracl...y_rel2_ds.html

    this thread might be useful for u

    http://dbforums.com/arch/50/2002/12/633671

    HTH

    SS

  5. #5
    Join Date
    Aug 2002
    Posts
    115
    can use oracle 9i transparent gateway for sql server...but aint free I suppose!!

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The gateway products are not free - you would need this http://www.oracle.com/gateways/gatew....html?faq.html at $15K.

    A poor-man's solution is to have a PC that pumps data between the two servers using ODBC - but I guess you could easily spend $15K making that work

  7. #7
    Join Date
    Jan 2004
    Posts
    14

    Post Srinivas

    Srinivas thanks for the reply and it was helpful .. The only problem is that is it useful for inserts and updates. I will try it real time and see. But from what I see in the example it is useful for only querying the sqlserver. I Want parallel updates from oracle

  8. #8
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    thats ok

    let me know if u have tested and implemented it.


    SS

  9. #9
    Join Date
    Jan 2004
    Posts
    14

    Thumbs up HSodbc works

    Thanks Srinivas HSodbc in oracle does the job beautifully

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