Oracle to Microsoft SQL Server 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
 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

Convert and synchronize databases from Oracle to Microsoft SQL Server/ Windows Azure SQL Databases efficiently and fast.

Automatic views conversion from Oracle to MSSQL is easily performed with DBConvert software even with no any knowledge in differences between SQL dialects.

Besides, any server access restrictions may be overcome by creating dump files instead of direct connection to a target database.

Data Migration between Oracle, Microsoft SQL Server and Windows Azure SQL Databases is possible in any combination.

DBConvert for Oracle and MS SQL Server easily handles huge databases and tables. A clear easy-to-use wizard interface helps you to move the whole database or only selected tables, indexes and foreign keys effortlessly.

Software comes with built-in scheduler, so you can run database migration and synchronization jobs at specified time intervals. Just define the schedule date and time and our programs will automatically execute sessions in the background.

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

Product Highlights

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

Interface languages

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

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

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.