ibm db2ms sql

IBM DB2 to MS SQL Migration and Sync

Our robust and cost-effective solution is a key for successful conversion and synchronization from IBM DB2 to MS SQL server.  Software is able to connect to source and destination databases directly without any other additional software installed. Optionally target SQL Dump file may be generated if you haven’t a direct access to the MS SQL server. 
 
User friendly interface can considerably reduce the time and efforts spent for migrating databases.  No SQL knowledge is required to work with our programs.
 
Software can also be launched from the command line with the predefined parameters previously stored as a session. 
Schedule any session to run at a time that is convenient for you or in response to a system event. 
 
The tool is also capable to move data between two MS SQL Servers or two DB2 databases.

Product highlights

  • DB2 v.9.7 and higher
  • Speed conversion with Bulk and Quantization features
  • 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

  • Microsoft Visual C++ 2008 x86 Redistributable package
  • If you connect to remote DB2 server that IBM Data Server Client should be installed on the machine where our tool is installed. You can download this client here: http://www-01.ibm.com/support/docview.wss?uid=swg21385217
  • Necessary privileges to write into empty database on the target DB2 server
  • 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)
IBM DB2 MS SQL

Converter from
IBM DB2 to MS SQL

  • 9 Sep, 2013
  • Version 2.0.1
ORDER From $149 DOWNLOAD 25.47 Mb

Synchronizer between
IBM DB2 and MS SQL

  • 9 Sep, 2013
  • Version 2.0.1
ORDER From $149 DOWNLOAD 20.98 Mb

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

From MS SQL to IBM DB2

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • Parameterized queries added. Synchronization/conversion speed increased by 15%.
  • SQL Azure support added.
  • Conversion/Synchronization speed boosting. Large databases with 500 records and more can be duplicated in 30-40 min that is in 100 times faster than before.

Screenshots

IBM DB2 to MS SQL: 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