Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
probably belongs on – 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)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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