Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 DBA.stackexchange.com –  Jim B Jan 12 '12 at 2:40
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.