HiT Software's DBMoto 6.5
March 19, 2009
Historically, database replication became a huge topic when distributed and homogeneous systems began to require information that was not readily available through common database connections or gateways. As an example, in the early days of Oracle, when SQLNet was not available, replication took the form of backup and recovery scenarios such as using export and import. This was not a huge issue twenty-plus years ago when databases were very small. However, the databases of the last 10 15 years require a much more robust mechanism to replicate data. The early approach to replication worked well in homogeneous environments but quickly fell apart when, say, someone needed to replicate data from an Oracle database to DB2. While most databases have replication abilities, both native and non-native, this causes some issues: each database vendor will more than likely have multiple methods of replication. Oracle, for example, has database links, Oracle Streams, Materialized Views, Warehouse Builder, and gateway products for replicating data between non-heterogeneous databasescomplicating not only the choice of approach but the staffs ability to maintain and administer multiple technologies effectively.
DBMoto from HiT Software is one of those products that cuts to the chase and supplies snapshot and real-time replication capabilities for all the major database platforms (IBM DB2 UDB, Oracle, Microsoft SQL Server, Sybase ASE, SQL Anywhere, Cloudscape, MySQL, Informix, Ingres, PostgreSQL, Microsoft Access, Gupta SQLBase, Firebird, and Solid). DBMoto helps remove the barriers to replication and enable users to quickly setup, schedule, and perform replicationeasily eliminating the need to learn complicated technologies and maintaining dozens of replication environments.
Working with DBMoto
DBMoto has, at a minimum, three connections it needs for performing replication. One connection is required for source database tables needing replication, one connection for the target database where data will be replicated to, and one connection to create, store, and retrieve metadata information about the replication process. This metadata does not need to reside in the source or target database and can be in any database or reside locally to the DBMoto tool.
While it is almost suggested that DBMoto should use .NET exclusively, I had read somewhere that an ODBC or OLE DB connection could be used for defining the connection to where the metadata would be stored. Wanting just to use the wizards in this product, I neglected to read the user guide that actually told you to right click on the metadata tag in the tree structures. Then after realizing that a box with three dots () enabled me to define connection attributes I was off and running.
1. Select database type and data provider
2. Enter the data source name and user credentials
3. Expand a tree structure of database tables to click which tables will be involved on the source or target sides
View table information
Setting up replication
DBMoto provides for different types of replication between the same or different database servers and platforms. It is just as easy to replicate from Oracle to Oracle, as it is to replicate from Oracle to MySQL. Replication with DBMoto can take on four distinct forms:
Simple and effective is the best way I can describe DBMoto. DBMoto is easy to set up, easy to configure,, and makes it easy to replicate between the major platforms. The strongest point about DBMoto is that it doesnt require a user to understand replication technology for all the major database environments. Replicating between Oracle, DB2, Informix, SQL Server, etc. is basically all the samejust point click and shoot. With a wide array of replicating options, scripting, and a nicely written user guide, DBMoto can easily be configured for a variety of environments. You can obtain a full working 30-day copy, with full support here: DBMoto Evaluation Download.