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…
Are you an Oracle DBA? Have you been asked to manage PostgreSQL or SQL Server databases?
Or maybe you’re a SQL Server DBA now assigned to manage “that one Oracle database that supports a mission-critical application…
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:
This post shares some highlights from the SharePlex 25th anniversary webcast that was held last month. In this celebratory webcast, five long-time Quest staffers shared their experiences in a round table discussion…
SharePlex is a database replication software that enables you to replicate from Oracle and PostgreSQL databases to a variety of platforms. Easily achieve high availability, increase scalability, integrate data, and offload reporting with this flexible…
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…
We are seeing more and more interest in our Stat customers moving their EBS and/or PeopleSoft applications to the cloud. It seems most of the moves currently are to Oracle Cloud Infrastructure (OCI). In some cases, customers are also moving Stat as well…
SharePlex® by Quest® was designed to address the HA/DR and horizontal scaling issues in Oracle databases. Building on this two-decade legacy, SharePlex for PostgreSQL now provides PostgreSQL database replication that solves many of these issues…
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…
My wife and I are foodies, and in addition to cooking and dining out, we enjoy watching some of the cooking competitions on TV. One of our favorite themes is when the celebrities are challenged to produce multiple dishes with the same ingredients.
Recently…
Are you considering migrating some of your Oracle workload to the cloud? Here’s why you should consider Quest SharePlex to help you reduce downtime and mitigate risk; and why Azure is worth considering as a cloud service
Your data…
Discussing migrations or replication from Oracle to other database flavors such as MSSQL, MySQL or PostgreSQL, the most frequent question I get from my customers and prospects is how to facilitate the initial load of the existing data. There are quite…
In my earlier 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.
Confluent has…
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
Patching, Upgrading or Migrating your Oracle Database can leave you feeling that you're in the midst of the same tornado that swept Dorothy into the Land of Oz; and you might run into some of the same characters as well. Here's how SharePlex, Quest's…
