Notification in case of data changes in SQL and Oracle

I am in the process of building a system where I need to开发者_运维问答 notify a Window Service in a .net based application in case of any change in the DB table (Insert , Update , Delete). I know this can be done with the ADO.NET Events in SQL. Is there any common solution for Oracle and SQL which can provide these kind of notifications. This needs to happen as and when the update happens on real time basis.

The only active push technology for SQL Server is Query Notifications, which works on very platform specific ways, like SqlDependency. Oracle has an equivalent in Data Change Notifications, which is just as platform specific. There is no common layer abstraction between the two, nor is there any chance of one to appear any time, given the huge differences between the two implementations.

BTW, technologies like Change Data Capture are designed for keeping disconnected clients in sync (ie. Sync Framework) and they are basically Replication in disquise, they are not suited for data change client notifications.

Both SQL Server and Oracle support Change Data Capture.

http://msdn.microsoft.com/en-us/library/bb522489.aspx

http://download.oracle.com/docs/cd/B10501_01/server.920/a96520/cdc.htm

You can capture the change and propagate it.

Also, there are third party products which will do replication between SQL Server and Oracle.