Migrating databases from Oracle to SQL Server can be challenging, particularly when character sets between the two systems differ. Mismatched character sets can lead to data loss, corruption, or issues with character encoding. In this blog, we'll explore…
Database migration from Oracle to PostgreSQL has become increasingly common as organizations seek to reduce licensing costs, embrace open-source solutions, and modernize their database infrastructure. However, such migrations present significant…
SharePlex customers often have questions about how SharePlex detects, processes and resolves situations where rows in the source and target databases are different.
SharePlex is designed to maintain synchronization between the source and…
Each year, SharePlex® by Quest® is regularly named as one of the Best Change Data Capture Solutions, if not the best, by Database Trends and Applications (DBTA) readers in their annual Readers’ Choice Awards. And now, DBTA has just named…
Do you have PostgreSQL databases that need to be replicated for Disaster Recovery or High Availability?
Would you like to share data between multiple PostgreSQL databases in near real-time?
Do you have data in an Oracle database you’d like to share to…
Data replication into the cloud offers several key benefits for organizations:
As a database administrator, you’re probably known in your organization for your pragmatic approach to technology. Sure, it’s important to continually hone your skills, but when somebody comes up with a new application-question, it’s more important to…
Database developers and DBAs have been using open-source databases, such as MySQL and PostgreSQL, for years. The platforms are mature, offer flexibility with low license costs and have a huge community following. Plus…
Our NEW webcast series is directed specifically at existing SharePlex product users. We call the series, “SharePlex Skills 101”, where we present topics that have a broad interest among administrators and users – people who use SharePlex often and are…
Dynamic data movement includes replication of data from a traditional RDBMS like Oracle to databases like MySQL, Azure SQL Database, Kafka and PostgreSQL.
Data is valuable because it contains all of the information that represents your organization. The…
Data to AWS Three Ways
A SharePlex Cookbook Part Two
In the first blog, I discussed data and a bit on SharePlex. Now for the recipes!
Here are the recipes - three different ways to get data from your Oracle database to either an Amazon File or…
As more and more Oracle users upgrade their databases to Oracle 19c and beyond, posts on the Oracle community mailing lists about changes in query performance are increasing. In most cases, users are seeing improved performance; but, as Scotty said in…
In my last blog, we discussed various business uses for turning Oracle database transactions into “business events”, and how SharePlex can be used to capture Oracle Change Data and write that data to a Kafka message queue.
In this blog, we…
Oracle and other relational databases are perfect for storing “transactions”, the results of interactions between people or systems. For example, when a customer purchases a widget from our store, we may need to perform the following steps…
Streams is Gone
If you're a current Oracle Streams user looking to upgrade to Oracle 19c, you already know that as of this release, Oracle has removed Streams. So, there are choices to be made. You can
In database replication, “immediately” never feels quite fast enough for your users, does it?
“We replicate transactions from production databases in real time,” you tell them. “You’ll see the change immediately, as soon as the transactions…
If you’re one of the busiest travel sites on the internet and want to perform an AWS cloud migration of your bookings database while simultaneously upgrading your Oracle version, you know that any interruption in service could be costly. It’s simply not…
In a previous blog, I discussed the differences between high availability and disaster recovery. Then, in my second post in this series, I looked at how SharePlex can help with disaster recovery. So, in this final post, I’ll discuss how Quest SharePlex…
In my earlier post, I defined the differences between high availability (HA) and disaster recovery (DR). I noted that in designing for DR, you want to build your secondary system so it will survive a large or widespread event, such as a hurricane, earthquake…
We all remember the movie that came out years ago about a dinosaur theme park where you could see living dinosaurs on an island. Everything worked great until the “bad” guys stepped in and crashed everything causing havoc and of letting the dinos out…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.
Sometimes it…
SharePlex peer-to-peer setup
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…
