Our software connects directly to source and destination databases. It does not use ODBC or any other middleware software to achieve the highest possible performance. Our improved engine allows converting approximately 1 Million records for 5-10 min.
Customize your data conversion process easily. You can copy your database as it is or modify the target database structure according to your requirements! All objects including tables, views, fields, indices and foreign keys can be tuned up before migration starts. (i.e. renamed or excluded).
These options have been added to the software to speed up migration / synchronization especially for large databases. Quantization option can handle large tables with millions of rows without exceeding the memory level. This is accomplished by splitting the whole record set into subsets.
The Bulk Insert option is valuable if your data processing is time-critical. It works significantly faster than quantization in times. This method uses the same memory size as conversion with default configuration. The quantization option is ideal for rational memory usage but it can take more time than usual conversion.
Synchronization tools are intended for comparison, data synchronization and replication between different databases. Comparison Identical, Different, Missing and Additional records are performed in the best way. Tuning up settings for implemented Insert, Update and Drop synchronization features, you are able to accomplish overall synchronization flexibly.
Trigger-based instant synchronization method increases synchronization speed in times.
Bi-directional sync allows replicating data in two directions to keep up-to-date data in all synched nodes.
Just check “Bidirectional sync” option at the Customization step and synchronizer will fulfill all the rest for you.
See the list of tools where Bi-directional synchronization is available below:
Cross database views or queries conversion is available for some of migration directions listed below
- MS Access queries to MySQL views
- MS Access queries to MS SQL views
- MS Access queries to PostgreSQL views
- Views conversion between MS SQL and MySQL in both directions
- Views conversion between Oracle and MySQL in both directions
- Views conversion between Oracle and MS SQL in both directions
An innovative parser provides the most efficient and the easiest way of view migration including the following types: simple queries of SELECT type, queries with standard functions (not including statistical with NZ prefix), cross table queries. Our software converts SQL queries COMPLETELY AUTOMATICALLY. No need to learn the differences in SQL dialects syntax. No special knowledge is required from your side.
Our Data migration programs take care about safety of your binary data! Applications support all binary data types (including `BLOBs`, `OLE Object` packages, BYTEA). All table structure, data, schemas (Oracle, SQL Server 2000 or higher, PostgreSQL), views/ MS Access queries, primary keys, indices and foreign keys (relations in MS Access), auto-increment (serial) and default value will be migrated.
Our software checks your database structure and relations in order to detect issues that can come up in migration to keep database integrity. Our tools display potential problems with your database objects BEFORE you’ve migrated! Some errors that could bring to the conflict on a destination database are easy to eliminate by a small reconfiguration of the conversion process issues in one touch.
With integrated Data Mapping feature you can easily match one data type to its closest and relative equivalent in target fields. Compatible data type assignment makes your cross database conversion more flexible.
You can get full control over the migration process with customizing integrated data filters. They allow users to split large amounts of data and to retrieve specific dataset according to defined filtering criteria. You can select needed tables, fields, indices, foreign keys, queries and views to proceed!
You can simply save your conversion job as a session in order to avoid configuring the migration process every time you start the program.
Use command-line mode to automate your export and import jobs using the saved session name as a parameter.
Conversion and synchronization task can be configured in all products with built-in Scheduling stage. With the help of sessions, the scheduled tasks will be started automatically as services in background mode giving you an opportunity to keep them unattended.
Find more information about Database Migration Scheduling Customization
Our database migration tools have the ability to establish a stable connection between different platforms and provide a secure tunnel for safe data running with optional SSH configurations.
You have the chance to create dumps and PHP scripts for indirect data uploading on MySQL, PostgreSQL, MSSQL, Firebird and Oracle. It will assist you to stay away from possible server restrictions.
Our products support Unicode architecture completely. They’re compatible with a lot of character sets (including Unicode utf-8) and associated standards.
You can get more information about specific features for different migration directions at appropriate pages. Please, proceed to product pages.
The names of actual companies and products mentioned herein may be the trademarks of their respective owners