Simple real-time data replication implementations!
How do you know that you’re choosing a real-time data replication software that’s simple to implement?
The premise for this blog is an to attempt to give you, the DBA, a visual on the ease of implementing HVR. With the DBA as a deciding factor in choosing a software to solve their real-time data replication needs. Here is a question a DBA may consider asking the replication software vendor:
What is the level of effort in implementing your real-time data replication software?
Why is this question important? Well, it’s you who’s going to be stuck with the implementation of whatever replication software is decided upon, you the DBA and your fellow DBA cohorts. To the point, implementation: HVR was built with implementation in mind. Even while your source systems are active, HVR can be up and running within a few steps. Minimizing the level of effort to implement a replication software that gives you in one implementation, the following HVR functions/components:
- Instantiating/Initial load – HVR Refresh will build your target tables (DDL) followed with data
- Replication – HVR’s Change Data Capture
- Validation – HVR will prove your data is sync
NOTE: The above three points are not separate. You truly need all three for a solid replication solution.
Now let’s break this down in the form of an implementation plan coupled with a level of effort plan.
TIP: the below can be copied and pasted into your project plan
1. Prep your source systems to accept HVR. A Quick Start Guide is provided to both active and trial customers. NOTE: This includes creating HVR OS user and HVRHUB db user. 5 min per source – 3 min per targets
2. Installing HVR Software 3 min per node (if applicable)
3. Configure replication using the HVR GUI
- Connect to your HVR HUB (schema or db)
- Define HVR Location
- Create HVR Channels
- Create HVR Groups
- Select your tables for replication
- Start HVR Scheduler
- Define your SOURCE systems
- Define your TARGET systems
- HVR Load – this preps your tables for replication
- HVR Refresh – This is the Instantiation/Initial Load part
- HVR Replication – Start CDC (HVR Software doesn’t care if your system is live)
- HVR Compare – To prove your systems are synchronized—10 min
4. DONE! Note: (bullets 3j and 3l are relative to the size of your data, the actual value will be supplied post QA benchmarking.)
Based on the above actual steps to implement HVR, replication can be up and running in under 25 minutes. And guess what? We don’t limit our functions, it’s truly a Total Cost of Ownership:
- Replicate a certain amount of tables
- All HVR functions included
Don’t believe it? Watch this video to see an HVR expert explain how to set up Oracle to SQL Server replication in minutes.
Test drive your own cloud instance of HVR right now with no obligation and see HVR’s simple setup and implementation for complex environments. Try HVR