Implement Asynchronous Change Data Capture
------------------------------------------
Key: CORE-4378
URL: http://tracker.firebirdsql.org/browse/CORE-4378
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Valdir Stiebe Junior
Priority: Minor
If you ever think about the built-in replication feature request (#CORE-2021),
please take the time to think about asynchronous change data capture.
ORACLE - http://docs.oracle.com/cd/B19306_01/server.102/b14223/cdc.htm
SQL Server - http://technet.microsoft.com/en-us/library/bb522489(v=SQL.105).aspx
Synchronous Change Data Capture is easily achieved using normal table triggers
under the performance penalty. So I think it isn't worth the time.
Today we use an AUDIT table that receives all the data generated by triggers.
An hourly process download the data to another database using "on external
datasource" feature.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
