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?