BTR2SQL Products from Mertech Data
While the Actian PSQL/Zen database engine is one of the fastest systems available on the market today for navigational access, there comes a time in the life cycle of any environment when the powers that be say "why Actian?". There are many arguments for PSQL/Zen, including cost savings for implementation, zero or very low administrative costs, and super-high performance. However, sometimes you simply run out of additional arguments to justify the database engine to a potential customer. Or, perhaps you are trying to sell your product into an environment where ALL databases have been mandated to be SQL Server. Or, the site may require enterprise-class replication and clustering capability that is still missing from PSQL. Or, you may simply not have the stomach to deal with Actian's recent changes to their licensing costs and policies. What's a developer to do?
Luckily, you have an easy migration solution available! Mertech Data created a product called BTR2SQL that can take an existing database application that uses the low-level Btrieve interface and port all of the database-level calls to a completely different back end, including SQL Server, Oracle, and PostgresSQL. This software can act as a translator, allowing the database to be physically hosted on one of these other platforms, without requiring that the entire environment be changed away from the BTRV or BTRCALL functions.
Note that this solution is NOT a simple drop-in to replace PSQL/Zen, and this is not a way to avoid buying licenses. Instead, this solution is designed for application developers who, for some reason or another, need to migrate their Btrieve-based application quickly off of the Actian platform while working on their full rewrite. There can be a substantial amount of effort required to get the data translated and the system tested and working on the new environment. Further, while the BTR2SQL API handles a majority of the Btrieve calls perfectly, you may have to handle any specialty function calls or work around processes which work in Btrieve but don't work in most SQL environments. The real goal of this software is to enable you to port your database to a new environment first, which can make it easier to continue using existing (legacy) code in your application while rewriting larger portions of the application to the new SQL interface.
For a bit more information, check out these resources:
If you are looking for more information about the features, costs, and benefits of this solution, or to set up a proof-of-concept environment to see your application working in a new back-end database, please contact Mertech Data directly, but let them know you found them from our site! If you have any issues with the data migration, we are just a phone call away and can assist with the BTR2SQL migration process, DDF creation, and more.
|
