Microsoft SQL Server to Oracle Migration.

 DBConvert for Oracle & MSSQL

Version: 2.0.7

Release Date: Oct. 15, 2014

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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa
 DBSync for Oracle & MSSQL

Version: 1.3.6

Release Date: June 24, 2015

Synchronization directions:

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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

DBConvert/ DBSync solutions to convert and synchronize SQL databases and Oracle databases are presented here.

Applications quickly move your data from MS SQL server/ Windows Azure SQL Databases to Oracle server and inversely.

Software reduces the risk of data migration loss by using a secure and reliable migration methodology. Applications give tip-offs about possible conversion and synchronization errors before starting the actual execution process. In Few easy steps your database migration project will be successfully completed.

You can customize all conversion and sync processes adjusting tools to your needs. Data export and import may be full or partial. The tools allow moving not only the total database but also its separate elements such as tables, fields, primary keys and constraints and indexes.

Conversion to Dump files, in addition to direct conversion to a server, is available in DBConvert tool.

DBSync for MSSQL and Oracle dependably and rapidly synchronizes your database from MS SQL Server/ Windows Azure SQL Databases to Oracle server and reversely.

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

Applications support the job launching automatically with the help of Built-in Scheduler. And they also have the possibility to be operated from the command line parameters.

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

Product Highlights

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

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)
  • MDAC 2.8
  • 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

  • Trigger-based instant synchronization method between Oracle and MS SQL found.
  • 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.