-
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
-
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
-
Thanks Santosh, I shall try it & get back to U
Regards,
Irfan
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|