Dynamic update from SQL Server 7.0 to Oracle 8.1.6
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Dynamic update from SQL Server 7.0 to Oracle 8.1.6

  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    2

    Cool

    Hello Friends,


    I have a table called PROFILE in SQL Server 7.0 which has the following 3 columns. Username, password, Email_Id.
    I also have a table called PROFILE in Oracle 8.1.6 which has the following 3 columns. Username, password, Email_Id. The data in the Oracle table is transferred/updated from the SQL Server table.


    The user logs on to the application & changes the his password. This password change is reflected in the SQL Server database because this application is attached to the SQL Server database.
    My requirement is to update the password column in Oracle database as soon as the password in Sql Server database is updated.


    Could anyone suggest any solutions at the earliest?


    Thanks In Advance,
    Irfan

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi Irfan,

    Try using Oracle Transparent gateway for microsoft sqlserver I have included a link for you about the above for further Info

    http://technet.oracle.com/products/g...lserver816.pdf

    Regards
    Santosh

  3. #3
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    2
    Thanks Santosh, I shall try it & get back to U


    Regards,
    Irfan

  4. #4
    Join Date
    Feb 2001
    Posts
    41
    good idea of transparent gateway
    you can also have snapshots or sqlserver every 2 mins apply them to oracle db
    Best Regards,
    Harsh Shah

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