More and more companies are moving their data and applications to the Cloud. Everyone talks about the Cloud, but this means different things to different people. When I talk about 'The … [Read more...]
May 15, 2013 by Leave a Comment
How to perform real-time Reporting on your data that is “stuck” in the Cloud
March 7, 2013 by Leave a Comment
Top 5 considerations when implementing a logical replication solution
In this post I want to look at how you can get your data flowing by implementing a real-time logical replication solution to replicate data between databases. Replication can solve many … [Read more...]
February 13, 2013 by Leave a Comment
Why Logical Replication is the Best Solution for Offload Reporting
My reports are taking too long! Running reports is a hardware intensive activity that can significantly impact the performance and availability of online production systems. Simply … [Read more...]
January 23, 2013 by Leave a Comment
How to update primary keys (PK) when using logical replication
Most people would agree with me when I say that updating primary keys (PK) is never a good idea because of foreign key constraints and integration or relationships with downstream and … [Read more...]
September 26, 2012 by
Activating Standby Database (failover)
Activating the standby database to become the primary database is also referred to as a failover. Failover happens in case of a disaster or severe failure on the primary site and users … [Read more...]
September 19, 2012 by 1 Comment
The 3 Fundamentals of Oracle Replication [Part 3 of 3]
This is part 3 of 3 in the series on "The three Oracle logical replication fundamentals". Part 1 can be found here The 3 Fundamentals Principles of Oracle Replication [Part 1 of … [Read more...]
August 29, 2012 by 1 Comment
How to: Insert Invalid Dates into Oracle and How to Replicate This
We recently came across a situation where the customer was using an ERP system running on top of an Oracle database and needed to replicate some of this data. The ERP is from a large … [Read more...]
August 21, 2012 by
What is a Standby Database?
Some things never change! Like standby databases (apart from updating of course). They are what they are. And explanation of what they are has resulted in one of our most popular posts. … [Read more...]
August 8, 2012 by 1 Comment
The 3 Fundamentals of Oracle Replication [Part 2 of 3]
This is part 2 of 3 in the series on "The 3 Fundamentals Principles of Oracle Replication". Part 1 can be found here. The second fundamental principle of logical based Oracle … [Read more...]
August 1, 2012 by 2 Comments
The 3 Fundamentals of Oracle Replication [Part 1 of 3]
Most logical based replication solutions in Oracle are based on extracting (or mining) the transactions out of the transaction log (redo logs) and transforming this into SQL statements … [Read more...]
