Smart Database Technology

Dbvisit Replicate 2.2 has been released and includes the following new features:

1. LOB support. Dbvisit Replicate now supports LOB datatypes.
2. Improved startup speed of dbvrep executable. The startup speed of the Dbvisit Replicate executable has been improved.
3. RAC support for node shutdown/startup. A RAC instance can be shutdown, and Dbvisit Replicate will continue to replicate when connected to the active instance.
4. One-to-many support. One source database can now have multiple target databases. This can be easily setup in the new setup wizard.

Dbvisit Replicate can be downloaded for a 30 day trial from here

Dbvisit Replicate offers Oracle-to-Oracle real time replication. It also supports Oracle-to-MySQL and Oracle-to-SQLServer. Dbvisit Replicate is simple to use and is a smart alternative to Golden Gate and Oracle Streams.

Dbman has a new look replete with skills to match! Check out his new proportions and replication abilities in his latest outing.

One month on from the release of Dbvisit Replicate CTO and Founder of Dbvisit Software, Arjen Visser shares some of the backstory on our newest product.

Replication software: who is using it and how can it be effective?

I see companies using Dbvisit Replicate for a number of reasons:

• Distributing data across offices/locations. They may have one source database that they want to distribute to remote offices, or have a need to share data with remote offices.
• Data warehousing, where ETL (extraction, transform and upload) is in play to extract data out of the source database and into the data warehouse. Using Change Data Capture (CDC) by mining the Oracle Logs is the most efficient way to detect and extract inserts and updates out of source data.
• Upgrading Oracle versions or migrating from one Oracle platform to another, e.g. Oracle on Windows to Oracle on Linux.

What are your keys to successful product development?
Successful software and ultimately product development is all about developing with the user experience in mind. My main considerations in developing Dbvisit Replicate were:

• Ensuring it was easy to use, configure and set up
• Making sure it provides solid and useful feedback when things are not going right, and that the software can guide the user in fixing whatever is wrong
• That it provided good guidance but still allowed for flexibility should the user wish to ‘wander off the path’.
• Ensuring that the product accommodated all of the different configuration options allowed by Oracle so our users did not lose any of the power and flexibility inherent to Oracle databases.

What prompted you to develop a Replication product?

Listening to our customers! We kept getting lots of enquiries from customers who wanted real time reporting and Oracle replication across different platforms.

What were some of the major challenges you faced in developing Dbvisit Replicate?

One of the biggest technical challenges around developing Dbvisit Replicate was building our own mining engine to extract the transactions out of the Oracle logs, putting the information together in the right order and turn them into SQL. Also ensuring that all the SQL are happening in the right order to guarantee transaction integrity. We figured it out!

What are some of the issues users have found since you launched Dbvisit Replicate?

All though we try to account for every Oracle configuration we can, by it’s nature replication is complex and there are configurations out there that we may not yet have accounted for. No doubt we will have to make changes to the software to accommodate them as they arise.

As with Dbvisit Standby we are very responsive when it comes to assisting customers and have been able to diagnose and resolve any issues very quickly.

What is your favourite feature in Dbvisit Replicate?

Real time replication progress updates which allow you to watch the replication as it happens in the Dbvisit Replicate console.

Is there still a place for DR software once someone has implemented Replicate?

Yes. They have very distinct functions and benefits: Dbvisit Replicate serves to replicate and distribute your data and Dbvisit Standby is about protecting your data. The great news for Standard Edition users is that Dbvisit products work together to provide the sharing AND complete protection of your data.

Is there anything else you’d like to add about Dbvisit Replicate?

I’m very excited about Dbvisit Replicate. Data replication is a very complicated animal (especially master to master) and it was a huge feat to pull off so I’m immensely pleased and proud of the team that we’ve been able to do it. I am also very excited that we can enable our users to replicate from Oracle to Oracle, Microsoft SQL Server and MySQL databases. It puts us in the unique postion of having two products that encompass the entire Oracle replication spectrum, from physical to logical replication. The possibilities this opens up for our primarily Standard Edition users is immense.

For more information on Dbvisit Replicate go to www.dbvisit.com.

Rapidly growing New Zealand software company launches real-time database replication product to immediate success
Demand for product sees Dbvisit make first sale prior to launch

Date: 18 August 2011
For immediate release

Dbvisit Software Ltd, developers of affordable disaster recovery solutions for Oracle® Database Standard Edition sites worldwide, announce the release of  Dbvisit Replicate to immediate success. A leading Software-as-a-Service (SaaS) health informatics company in the US has chosen the product to enhance their service offering; accessing its real-time Oracle to MySQL database replication functionality to provide affordable real-time business reporting for their customers.

“Dbvisit Replicate has immediate appeal for businesses looking for an affordable, real-time Oracle database replication solution,” says Arjen Visser, CTO & Founder of Dbvisit. “We listened to what our customers and partners were telling us and are pleased to have made our first sale prior to launch.”

Dbvisit Replicate’s ability to share, migrate, synchronise and consolidate data in real-time effects benefits at all levels of a business. By providing improved database resiliency, offloading processing workloads and facilitating the integration of diverse platforms, operating systems and databases, Dbvisit Replicate presents businesses with a real opportunity. They now have the ability to minimize administrative system downtime, realize operational cost efficiencies in infrastructure, facilitate real-time business reporting and improve their users’ overall systems experience.

http://www.dbvisit.com/replicate_download.php

For further information please contact:

Libby Russell, Marketing Manager
Arjen Visser, CTO & Founder
Tel: +64  (0)9 950 3301
www.dbvisit.com

About Dbvisit Software Limited
Businesses in over 60 countries worldwide with Oracle® Database Standard Edition software trust Dbvisit to protect and share their data enterprise-wide. By eliminating the need to upgrade to Oracle® Enterprise Edition to access Data Guard or to purchase Oracle ® Golden Gate, our customers can save significantly on their disaster recovery and data replication solutions.

Our products are designed to be ‘set and forget’. They are simple to install and manage, functionally rich and come with comprehensive documentation and support. We provide peace of mind for our users, freeing up their valuable time to focus on other business activities.

Dbvisit Software Ltd is a wholly owned subsidiary of Avisit Solutions Limited, founded in 2000. We are headquartered in Auckland New Zealand with sales offices in the USA and France. www.dbvisit.com