SQL Server to Oracle Migration.

 DBConvert for Oracle & MSSQL

Version: 2.1.4

Release Date: Feb. 12, 2020

Conversion directions:

  • Oracle → MS SQL Server, MS SQL Dump
  • MS SQL Server → Oracle, MS SQL Dump
  • Oracle views ↔ MS SQL Server views
  • Oracle ↔ SQL Azure
  • Oracle ↔ Amazon RDS ↔ MS SQL Server
 DBSync for Oracle & MSSQL

Version: 1.4.1

Release Date: Nov. 14, 2018

Synchronization directions:

  • MS SQL Server ↔ Oracle
  • Oracle ↔ SQL Azure
  • Oracle ↔ Amazon RDS ↔ MS SQL Server

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.

Product Highlights

  • Speed conversion with Bulk and Quantization features
  • Oracle 10.x.x/ 11.x.x/ 12.x.x, Oracle XE (Express Edition) located on Linux, Solaris, Mac OS X, Windows machines
  • MS SQL Server (Express) 2000/2005/2008/2008 R2/2012/2014/2016, SQL Azure support
  • Amazon RDS Oracle DB Instance support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Amazon RDS SQL Server DB Instance support
  • Views conversion from Oracle to MS SQL and MySQL and back support
  • Saving data into an Oracle Dump for export to Oracle database
  • ODBC Oracle and Oracle client are not required
  • Saving data into a MS SQL Dump for export to MS SQL database
  • MS SQL schemes support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL

Product Requirements

  • Necessary privileges to write into database on the target Oracle server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • Oracle 12.x versions require Oracle Database 12c Release 2 Client ( for Microsoft Windows (32-bit) to be installed:
  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)

Latest News

  • Parameterized queries added. Synchronization and conversion speed increased approximately by 15%.
  • Simultaneous synchronization in both directions added.
  • SQL Azure support.
  • High-speed stability conversion for large databases (approximately 1 million records). They can be transferred:
    - in 7 min when Oracle is a source (with "Bulk" option activated).
    -in 9 min when MS SQL is a source .
  • Views conversion support for Oracle and MS SQL databases added.
  • Trigger-based instant synchronization method between Oracle and MS SQL found.