ms sqloracle

MS SQL to Oracle Migration and Sync

A wide-ranging solution to convert and synchronize SQL databases and Oracle databases. Applications quickly move your data from MS SQL server to Oracle server and inversely from Oracle server to SQL server. Few easy steps successfully complete any database migration project.

Software reduces the risk of data migration loss by using a secure and reliable migration methodology. You can customize all conversion and synchronization 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 converter tool. Sync tool has the three sync types and Trigger-based database sync methods to replicate any data change to the target db.

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. Moreover, tools give tip-offs about possible conversion and synchronization errors before starting the actual execution process. .

Our software is available and affordable for everyone. It’s easy to use and always improving.

Product highlights

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

Requirements

  • 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)
  • 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)
MS SQL Oracle

Converter from
MS SQL to Oracle

  • 9 Oct, 2013
  • Version 2.0.3
ORDER From $149 DOWNLOAD 64.32 Mb

Synchronizer between
MS SQL and Oracle

  • 15 Apr, 2014
  • Version 1.3.3
ORDER From $149 DOWNLOAD 64.44 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From Oracle to MS SQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • 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.

Screenshots

MS SQL to Oracle: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions