DBSync for Oracle and MS SQL

DBSync for Oracle and MS SQL

DBSync for Oracle and MS SQL

Developer’s Description

By DMSoft Technologies
DBSync for Oracle and MS SQL is a database synchronization tool which performs two-way conversion and synchronization from Oracle databases to MS SQL server and from MS SQL to Oracle. The tool is also applicable for MS SQL database replication to another MS SQL database and is quite adept at copying a Oracle database to another Oracle database. DBSync for Oracle and MS SQL provides the bulk of functional capabilities such as interactive (GUI) mode/command line mode, savable sessions, insert, update and drop synchronization types included, task planner scheduling, data filtering, preverification of possible conversion errors. You can convert and synchronize Oracle with MS SQL or MS SQL with Oracle simply by configuring several options and by making some sync customizations through a Wizard interface or in command line mode. Command line parameters added to a scheduling function enables you to automatically synchronize or convert data regularly without user input and supplementary settings. DBSync for Oracle and MS SQL provides you with the ability to manipulate synchronization preferences on Customization stage exactly according to your needs. Filtering data during conversion allows users to retrieve only specific data for converted tables according to defined filtering criteria. Filters give you more control on the data migration process. Possible synchronization errors can be detected before the conversion process gets started. The tool displays errors and potential problems with your table objects beforehand.

Download DBConvert Products

Trial versions are free to download. You can test them for an unlimited time period. Payment is required if you found our software useful and wish to use it without limitation.

Trial versions limitations

DBConvert series:

All records for each database table are converted. Character data after 50 first records is watermarked with ***TRIAL*** text. The trial will allow you to evaluate the migration process flow and conversion speed provided by DBConvert.

DBSync series:

When the Trigger-based sync option is activated, it will synchronize the 5 first records. However, the remaining records will not be processed. You will be able to see actual processing time. Without triggers, the software syncs only the first 50 initial records for each database table.

When copying data without the syncing options checked, the first 50 records will be converted completely for each database table. All character data after the first 50 records is watermarked with ***-TRIAL-*** text.

Convert SQL Server to Oracle.

Our DBConvert/ DBSync solutions will convert and synchronize your SQL databases and Oracle databases.

These applications quickly move your data from MS SQL server/ Windows Azure SQL databases to Oracle server and conversely.

Our software reduces the risk of data migration loss by employing a secure and reliable migration methodology. Applications give preemptive messages about possible conversion and synchronization errors before starting the actual execution process. In just a ew easy steps your database migration project will be successfully completed.

You can customize all conversion and synchronization processes, adjusting the tools to your specific requirements. Data export and import may be full or partial. The tools allow moving not only the entire database but also the separate elements including tables, fields, primary keys, primary constraints and indexes.

Conversion to Dump files, in addition to direct conversion to a target server, is supported in the DBConvert tool.

DBSync for MSSQL and Oracle reliably and rapidly synchronizes your database from MS SQL Server or Windows Azure SQL databases to Oracle servers and conversely.

DBSync has insert, update and drop synchronization. Boost your database synchronizations using our trigger-based sync feature and you’ll notice that the processing speed is much faster.

Our applications support automatic job launching with the help of our built-in scheduler. They also support command line operation.

Different types of synchronization are also available for keeping your databases up-to-date.

Overview

Editor: Synchronize and convert databases from Oracle to MS SQL or from MS SQL to Oracle rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for Oracle & MS SQL is also applicable for MS SQL database synchronization and migration to another MS SQL database or even to another MS SQL server. Moreover, DBSync for Oracle & MS SQL is quite well for Oracle database synchronizing and migration to another Oracle database or to another Oracle Server.

Safe data synchronization and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBConvert for Oracle & MS SQL supports all base data types of Oracle Server and MS SQL server data types. Primary keys, indexes and foreign keys are supported in the best way.

Preverification of possible conversion errors.
Verify possible conversion errors before the conversion process gets started! To Prevent is better than to correct! Our tool displays errors and potential problems with your table objects beforehand. 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.

Optimal data mapping
Simple data types assignment for a destination database in one touch. Just choose data types you need for The Target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.

Update, Insert and Drop synchronization
Keep all your databases up-to-date. Insert synchronization is meant for new records adding from a source to a destination database. Update synchronization is meant for replacing of the altered records in destination database.

New

DBSync for Oracle & MSSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:
-Oracle to MSSQL
-Oracle to Oracle
-MSSQL to Oracle
-MSSQL to MSSQL
Synchronize and convert databases from Oracle to MS SQL or from MS SQL to Oracle rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed!
Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for Oracle & MS SQL is also applicable for MS SQL database synchronization and migration to another MS SQL database or even to another MS SQL server.
Moreover, DBSync for Oracle & MS SQL is quite well for Oracle database synchronizing and migration to another Oracle database or to another Oracle Server.
Main features:
-Primary keys and Indexes support;
-Foreign key (relations) support;
-Insert-synchronization, Update-synchronization and Drop-synchronization available;
-Database objects (tables, fields, indexes and foreign keys) remapping;
-Oracle Server version 10.0 and higher support;
-ODBC Oracle and Oracle client are not required;
-Unicode support, all possible encoding support;
-Advanced customization options:
– partial selection for database objects to be converted.
– database objects (tables, fields, indexes) renaming before conversion.
– detection of possible conversion errors at customization stage.
-Sessions support – all your settings can be saved and restored then;
-Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
-BINARY` conversion support;
-Skins support;
-Multilanguage Support;
-Interactive (GUI) mode / command line mode;
-Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MS SQL internal purposes) with a substitute symbol;
-Automation of the conversion process with built-in scheduler;
-Data mapping – simple data types’ assignment for a destination database to match one data type to its closest equivalent in the target fields;
-Ability to select table types when copying data to MS SQL;

Leave a Reply

Your email address will not be published. Required fields are marked *