New in SQL Server 2012 is a Change Data Capture for Oracle by Attunity which allows you to continually copy data from Oracle to SQL Server. This feature is helpful in two common business scenarios: 1. Migrating from Oracle database to SQL Server 2012 systems - you can synchronize criticial tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server 2012 tables. 2. Data Warehousing using a SQL Server 2012 system. Changes can be capture from your Oracle database and sent to SQL Server 2012 databases to keep the data warehouse in sync.
Download and Setup information:
SSIS Data Flow components and Control Flow task
Troubleshooting Guides
Please check to see if it's possible to use CDC with an Oracle Partitioned table.
Patris_70 edited Revision 5. Comment: added en-US tag and title
Richard Mueller edited Revision 7. Comment: Removed (en-US) from title
Is it possible with Oracle table views?