Differences

This shows you the differences between two versions of the page.

sqldata:oracle-to-db2 [October 31, 2012 12:31 pm] (current)
sqlines created
Line 1: Line 1:
 +====== SQLData Tool - Database Migration from Oracle to IBM DB2 ======
 +SQLData is a scalable, high performance data transfer, schema conversion and validation tool for Oracle to IBM DB2 migration.
 +
 +The tool allows you to move and validate the migration of large volumes of data and database schema within the shortest possible time frame.
 +
 +
 +===== Why SQLData =====
 +
 +SQLData benefits:
 +
 +**Scalability and High-Performance**
 +
 +  * Transferring tables in multiple concurrent sessions
 +  * Performing concurrent read and write operations in each session
 +  * Using Oracle OCI with array processing to extract data from Oracle
 +  * Using DB2 CLI API with array processing to load data to DB2
 +  * C/C++ application, 32-bit and 64-bit
 +
 +**Designed for DBAs and Enterprise-Class Migrations**
 +
 +  * Easy to set up and configure the transfer of a large number of tables
 +  * Command line with powerful and easy to use options
 +  * Wildcards to select tables
 +  * Comprehensive performance stats to help you tune the data transfer
 +  * No space required to hold Oracle export
 +  * No ADO.NET providers required
 +  * No .NET dependency
 +  * No installation required
 +
 +====== SQLData Editions ======
 +
 +SQLData is available in Express, Standard, Professional and Enterprise editions:
 +
 +| |  **Express**  |  **Standard**  |  **Professional**  |  **Enterprise**  |  
 +| **Database Size** |||||
 +| //Data Volume per Database// |  3 GB  |  10 GB  |  100 GB  |  Unlimited  |
 +| //Number of Tables// |  Up to 100 |  Up to 300 |  Unlimited  |:::|
 +| //Number of Rows// |  Unlimited  |  Unlimited  |:::|:::|  
 +| //Number of Databases// |:::|:::|:::|:::|
 +| **Schema Conversion** |||||
 +| //CREATE TABLE Statement// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //NOT NULL Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //DEFAULT Clauses// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //CHECK Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //Primary and Foreign Keys// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //Unique Constraints// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //Indexes// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| **Schema Transformation** |||||
 +| //Schema Name Mapping// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  
 +| **Validation** |||||
 +| //Validation by Row Count// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  
 +| **Performance and Scalability** |||||
 +| //Parallel Sessions// |  Up to 2  |  Up to 4  |  Up to 8  |  Unlimited  |  
 +| //Concurrent Reader/Writer in Each Session// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //Table Partitioning Support// |  {{:red_cross.png|}}  |  {{:red_cross.png|}}  |  User-defined only  |  {{:green_tick.gif|}}  |  
 +| //32-bit Version// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  
 +| //64-bit Version// |  {{:red_cross.png|}}  |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  
 +| **Automation** |||||
 +| //[[/sqldata_cmd|Command Line]]// |  {{:red_cross.png|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  
 +| **Licensing and Support** |||||
 +| //Technical Support// |  Basic  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |
 +| //Price// |  Free  |  $375  |  $975  |  $1,735  |
 +
 +If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]].