Dynamic update from SQL Server 7.0 to Oracle 8.1.6

[mir_irfan]

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

[santoshym]

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

[mir_irfan]

Thanks Santosh, I shall try it & get back to U


Regards,
Irfan

[hbk_emp]

good idea of transparent gateway
you can also have snapshots or sqlserver every 2 mins apply them to oracle db