Maintaining multiple database platforms is a way of life for most organizations. Each platform supports its own application type, but businesses almost invariably need to exchange data between different database platforms.
SQL Server's built-in replication has limited support for other database platforms. HiT Software's DBMoto solves the problem of cross-platform communication through real-time database replication between almost all popular database platforms, including SQL Server, IBM DB2UDB,IBM iSeries,Oracle,Sybase ASE, SQL Anywhere, Cloudscape, MySQL,
Informix,Ingres, PostgreSQL, Microsoft Access, Gupta SQLBase,Firebird, and Solid.
They are four types of drivers can we utilize into Database connection using DBMoto.
With DBMoto, HiT Software brings real-time data replication and data integration with:
-Low Total Cost of Ownership (TCO)
-Heterogeneous Database Support
-Interoperability with Legacy Systems
-Accelerated implementation/faster time to market
-Non-proprietary and standards-based
-High reliability and proven performance
-Responsive, expert technical support
-Available in 32-bit/64-bit
Refresh mode is essentially snapshot replication:
DBMoto sends a point-in-time copy from the source to the target system.
Mirroring mode is like transactional replication: Real-time changes are sent from the source to the target.
Synchronization mode enables bidirectional replication beween the source and the target.
DMoto can automatically convert data types as well as perform data transformations using Visual Basic .NET scripts.
A grouping feature lets DBMoto intelligently handle common connections to remote databases.
After defining the source and target, you use the Replication Wizard to set up the replication type,
the source and target connections, the data mapping, and the schedule. To support transaction replication on the IBM i, DBMoto required journaling to be active for the files being replicated.
The above figure shows the Replication Wizard's data mapping screen, which lets you do simple one-to-one mapping.You can use the toolbar to edit the mappings to differently named columns and optionally elect to perform transformations on selected columns.
DBMoto was easy to use, and it supports almost all of today's popular databases. If you're looking for a solution to your heterogeneous transactional database replication problems,
DBMoto has the answer.
Download DBMoto, a full 30 day support.
Regards,
Veera,
SystemEngineer,
ClimbInc,Nihombashi,Tokyo.
Here QAFP is the Library name and DBRSJ00001 is the receiver name and Autherity for ALL.
Here QAFP is Library Name and DBRSJ is Journal Name.
Here QAFCTUTDBF is a Physical Table name. 
