Oracle to MS SQL Migration and Sync

Convert and synchronize databases from Oracle to MS SQL Server efficiently and fast. Automatic views conversion from Oracle to MS SQL is easily performed with our 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.

Our tool 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.

Read here trial versions limitations

Product highlights

• 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
• 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
• Also see common features for all DBConvert tools

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)