We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.

What is a good method to automate a one-way, read-only synchronization/replication/dump of a 400GB Oracle 11g database to MSSQL 2008R2 while minimizing the data moved? The 400GB data will be a ETL/subset snapshot of a larger database, so no direct backup/restore, and I believe the data will be flushed between snapshots and not be an incremental update.

Due to the sensitivity of the data, and the relationship of the business units, I think the best we're going to be able to do is get either an ETL to a separate Oracle DB or possibly views, then we need to take it from there.

The servers will be in the same data center, so assume low-latency high bandwidth access.

  • probably belongs on DBA.stackexchange.com – Jim B Jan 12 '12 at 2:40

Configure the Oracle DB as a replication publisher, and set up transactional replication to the MSSQL DB (the subscriber):

How to: Create a Publication from an Oracle Database (SQL Server Management Studio)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.