Skip to main content

HVR is now a Fivetran enterprise solution. LEARN MORE.

/blog How To: SQL Server Data Replication

by MarkVan de Wiel

SQL Server Data Replication Done Fast and Reliably

Data Replication for SQL Server and Heterogeneous Environments

An overview, how-to videos and a case study to see how easy it can be to use HVR for SQL Server Replication Scenarios in Heterogeneous Environments 

Although OrMicrosoftSQLServer Data Integrationacle has long been the market share leader among database vendors in terms of revenue (mostly from large enterprises), Microsoft SQL Server leads the commercial database market in terms of the number of installed instances. SQL Server is appealing to organizations because it is (still) relatively inexpensive, features comprehensive functionality, is supported by a large ecosystem, and has the backing and support of one of the largest software companies in the world.

Many of our customers use HVR for heterogeneous real-time data replication from Oracle and other non-Microsoft databases to SQL Server in order to power a broad range of OLTP, data warehousing, business intelligence, and analytics workloads. Demand for SQL server data replication is continuing to grow, driven in large part by SQL Server 2014 enhancements in areas such as in-memory processing, columnar storage, expanded BI and reporting services, as well as the growing popularity of Microsoft Azure cloud services.

The appeal of HVR for these heterogeneous environment use cases is that the solution is fast and easy to implement, requires no downtime, and ensures that no data is lost or corrupted.

How to: SQL Data Replication Deployment in a Matter of Minutes

Assuming that source and target operating system and database users have been set up with appropriate privileges, deploying an HVR SQL Server Data replication environment can be completed literally in a matter of minutes:

1. Replication Set-Up: A GUI guides the administrator through the steps of installing the software, connecting to the hub, defining locations, creating channels, and defining actions. HVR automatically creates target tables and maps heterogeneous source data types to SQL Server data types. The time it takes to instantiate the target system is simply determined by the data volume and available system resources to run the initial data refresh.

2. System Availability: Systems do not need to be taken down during installation, setup, or at runtime, and minimal overhead is imposed on source and destination systems while jobs are running. In most cases, log-based change data capture is employed on source systems, and optimizations are used at the destination to ensure scalability for large data volumes. Robust scheduling and operations services enable lights out, continuous or on-demand integrations. And if a job is interrupted for any reason, it can resume where it left off.

3. Data Validation: To ensure that source and target systems are in sync and that no data is lost, HVR features Database Validation and Refresh/Repair functionality. This can be performed in bulk mode, or table by table and row by row. In either case, the capability is extremely useful for monitoring data consistency and integrity, particularly among heterogeneous systems with different schemas.

SQL Server Data Replication Video Tutorials: See How Easy It is Replicating to and from SQL Server Using HVR.

Following are a couple ten-minute videos showing how easy it to replicate to and from SQL Server using HVR.

Oracle to SQL Server Data Replication

SQL Server Replication  to PostgreSQL

SQL Server Replication Made Easy from a Remote Location

MobiCom uses HVR to offload data from Oracle to SQL ServerHVR Customer, MobiCom, is based in Mongolia. MobiCom Corporation (Mongolian: Мобиком Корпораци) is the largest mobile phone operator in Mongolia. Established in 1996, MobiCom pioneered mobile technology in Mongolia where it today has 33 percent of the mobile service market. MobiCom has been pivotal in transforming Mongolia’s economy by providing essential telecommunication services including long-distance and local telephone services, facsimile services, TV and public card payphones, internet services, and prepaid card services.

As MobiCom’s network coverage spread to 95 percent across the country, the widest range of coverage in Mongolia, and grew to deliver services through 64 branch units, 2,200 dealers and over 10,000 mobile sales points, handling the data load on its back-end systems became a challenge. Sitting at the core of data processing were two large Oracle databases, installed to process call record and billing transactions, while also providing the back end of MobiCom’s corresponding business intelligence solutions. With mobile subscriber data management set to become a $2 billion market by 2019, the data load would only increase. Replacing the database hardware would be necessary but costly to do on a regular basis and was not a scalable long-term solution.

Cost-effective and easy-to-learn Solution

The IT team was given the mission-critical task of re-engineering the online transaction and business intelligence architecture so that both could scale to meet the coming demand with room for MobiCom to continue to innovate with new and improved services. The transition from the old to new architecture also had to be seamless without affecting customer or business activities while also being cost-effective with little to no new training or third-party consultation.

After a thorough search, MobiCom identified HVR Software as an expert in dealing with these types of complex database integration challenges. HVR was able to provide an easy to install and use replication technology that could off-load reports to a heterogeneous database with minimal set-up. And because MobiCom identified their new business intelligence
a system to be based on Microsoft’s SQL Server Reporting Services (SSRS), MobiCom was delighted that HVR was heterogeneous and could replicate in real-time to SSRS all of the changes occurring in the Oracle database.

HVR made the data off-load much easier because it could automatically create new SQL Server tables based on their Oracle definitions, efficiently load the large Oracle tables into SQL Server, and keep up with their real-time change activity while having room to grow. HVR’s ability to perform log-based capture on Oracle was another bonus because it had minimal impact on the already heavily-loaded Oracle systems. HVR was able to quickly complete the installation process without any additional training or consultancy services required. This reduced MobiCom’s overall project cost and meant that once installation was complete, the benefits were seen immediately.

For the full case study, you may download it from here.

Have questions or would like to talk to us about your SQL Server Scenario? We can show you in less than ten minutes via demo.

What to read next

Data Security and SOC 2 Certification
Data is one of the most important assets to modern organizations. Organizations digitally transform to [...]
Read on
HVR SAP AppConnect
HVR stands for High Volume Replication. The technology is renowned for helping enterprise customers implement [...]
Read on