Data replication
and data migration
software
Repstance is real-time replication tool for SQL Server and Oracle databases, which has highly advanced replication and transformation abilities.
Repstance is currently listed on the AWS and Azure platforms and supports:
Oracle 10G - 19C and any version of SQL Server that permits the use of CDC (Change Data Capture) as Source Databases. Oracle 10G - 19C, SQL Server, MySQL, PostgreSQL, Amazon Aurora, Amazon Redshift, Snowflake and S3 as Target Systems.
Deliver your data to multiple consumers with only one tool
Repstance is an extremely reliable
Database migration and replication tool!
Repstance has been created as a product that propagates the maximum amount of data at the highest possible speed with minimal impact on the source and target databases and the highest possible degree of security and integrity.
As a premier data transfer tool, Repstance is used by companies to solve multiple types of tasks - from simple migrations to complex and ongoing replications.
Repstance Initial Load functionality is used to copy a high volume of data from the source to the target database.
To achieve the best performance, Initial Load uses various database features such as:
- "bulk load"
- "parallelism"
- "staging load"
which allows Repstance to quickly move the initial set of objects and data without having any additional tools involved in the synchronization process.
Initial load is extremely useful when it is necessary to transfer tables taking into consideration: data type remapping, data conversion, object naming, any transformation rules, and especially in heterogeneous replication scenarios, such as:
- Oracle to Snowflake data replication
- data migration from SQL Server to PostgreSQL
- etc.
Repstance has the functionality to support Data Modification Language (DML) and Data Definition Language (DDL) operations, which can be automatically included in the replication stream and, if desired, uses sophisticated transformation and data filtering abilities.
Repstance implements sophisticated deeply researched algorithms that extract and apply data, depending on:
- number of objects being changed;
- number of changes;
- types of changes;
- specifics of transactions;
Which is how it makes Repstance replications one of the fastest amongst any other solution.
Enabling DDL replication forces Repstance to track and replicate any structural changes occurring to tables including, but not limited, to table creating, dropping, and renaming tables, any columns’ modifications, adding and dropping partitions, sub-partitions, modification of primary keys and unique indexes. These changes are automatically included during DML replication and do not require any manual User intervention.
Repstance propagates data into the Target Database in the same order they were executed in the Source Database, which means that both Source and Target Databases will be synchronized in a “Consistent State”.
The data extracted by the Capture Process is written to the Trail Files in the same sequential order as the transactions that occurred in the Source Database, which in turn allows the Apply Process to insert this data into the Target Database in the same order they were executed in the Source Database. This means that both Source and Target Databases will be synchronized and keep your data entirely consistent across all your databases.
Repstance supports various types of data transformation and filtering, which are primarily used where there is a need to reformat any statements. Using transformations allows replicating data between tables with different structures, adding custom data processing logic, using SQL functions for data processing and enrichment, etc.
Transformations can also be enabled for DDL replication, meaning that any DDL statements will also be affected by the transformation rules.
Transformations are widely used for various Zero Downtime Upgrade or Blue Green Upgrade scenarios when it is necessary to support replication for databases that are running on different versions.
Filtering capability allows specifying of a subset of data using SQL-based conditions, which are not affected by DML operations. For example, using filters, you can prohibit the cleaning of any data, giving you the means to restore it from the target database, if data was deleted by mistake, or not to permit the insertion of sensitive data into the target system, etc.
Instead of covering all the possible source and target database types, as an excellent Data replication tool supplier we focused on the most popular ones. These are Oracle and SQL Server - as such we really excel in them!
Repstance fully supports heterogeneous data propagation, meaning that data from Oracle or SQL Server databases can be replicated into any of supported Target databases, which are:
- Oracle
- SQL Server
- PostgreSQL
- Aurora (using either PostgreSQL or MySQL engines)
- MySQL
- MariaDB
- Redshift
- Snowflake
- AWS S3
Repstance has a wide range of parameters allowing you to customize and fine-tune the replication process to meet complex data propagation requirements and successfully function when others failed.
As a premier Data replication tool supplier we provide different configuration approaches.
Our product is available as an out-of-the-box cloud solution in both AWS and Azure marketplaces. It gives you the ability to set up everything as fast as possible.
To meet specific needs we provide custom on-premises deployment versions. Since we do our best to make complex migration and replication tasks as simple as possible, we create a few ways to interact with Repstance:
WebUI is an easy and intuitive way to configure replication using a Web browser only, while Repcli and JSON are primarily used to integrate Repstance with external tools and deployment systems such as Terraform or Cloud Formation.
We understand the value of your data and pay special attention to our client's support.
Our support team is available 24/7 and provides extensive expertise as standard including, but not limited to choosing the best configuration based on your needs.
Our experts can walk through all the steps of the process of maintaining Repstance from start to finish.
Contact our support team and we will schedule a call to demonstrate Repstance’s capabilities and discuss all your needs.
If Repstance meets your requirements we will provide you free trial licenses and full support of the product. Our technical specialists have deep knowledge and expertise in data migration and replication projects and are happy to review your databases to advise on the best approach, help with product setup and configuration, and participate in POC implementation.
With our support team, you will be able to evaluate Repstance in your environments without the necessity to buy it.