Database Migration

Database Migration    Technologies


Database Migration is a complex process, requiring a robust methodology along with tools. Automated tools along with deep understanding of source and target platforms are key for successful platform migration. At Modak Analytics, we have significant expertise with Database Platform migrations. We have developed tools which automate significant portion of the complex migration.

Modak Analytics has Robust Methodology that covers all aspects of Database Migration including Unit Testing, Integration Testing, User Acceptance Testing, and the critical 'cut-over' planning to smoothly transition from DB2 to Netezza.

  • DB2 to Teradata Migration
  • DB2 to Netezza Migration
  • Teradata to Netezza Migration
  • Teradata to DB2 Migration
DB2 to Teradata Migration

DB2 with BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex.

Manual migrations are cost intensive and highly error-prone. Modak Analytics 'automated tools' and expertize will speed up the conversion process, minimize downtime and deliver an optimized solution. With a team of highly trained services professionals, we can help you migrate while making sure your business, performance and SLA goals are met.

Modak Analytics's Comprehensive Migration Acceralator tools and program will help with:

  • SQL DDL statements (Create Table, View, Index etc)
    • Datatype Conversion
    • Intelligent Migration of Hash AMP Keys to DB2 Hash Partition Keys
    • Migrate User Accounts, Grants, and Privileges
    • Views along with SQL
  • SQL DML statements (Select, Insert, Update, Delete etc)
  • Teradata Join Index, or Aggregate Index to DB2 MQTs

In addition, Modak Analytics will help you with:

  • Migration of BTEQ scripts to either perl/shell scripts, or formal ETL tool
  • Migration of FastLoad, MultiLoad to load scripts or formal ETL tool
  • Migration of Load Scripts, ETL Routines (including IBM DataStage, and Informatica)
  • Migration of Business Reporting Tools (e.g. Cognos, Business Objects etc)
  • Migration of other code accessing Teradata (e.g. SAS, Crystal Reports, Custom Java Applications)
  • Migration of Stored Procedures
  • Migration of User Defined Functions (UDF)
  • Scripts for one-time bulk migration of existing Data from Teradata to DB2
IBM DB2 to Netezza Migration

Netezza transforms the data warehouse and analytics landscape with a platform built to deliver extreme, industry-leading price-performance. With simple deployment, out-of-the-box optimization, no tuning and minimal on-going maintenance, IBM Netezza data warehouse appliance has the industry's fastest time-to-value and lowest total-cost-of-ownership.

Manual migrations are cost intensive and highly error-prone. Modak Analytics 'automated tools' and expertize will speed up the conversion process, minimize downtime and deliver an optimized solution. With a team of highly trained services professionals, we can help you migrate while making sure your business, performance and SLA goals are met.

Modak Analytics' Comprehensive Migration Accelerator tools and program will help with:

  • SQL DDL statements (Create Table, View, Index etc)
    • Datatype Conversion
    • Intelligent Migration of DB2 Hash Partition to Netezza SPU Hash Partition
    • Migrate User Accounts, Grants, and Privileges
    • Views along with SQL
  • SQL DML statements (Select, Insert, Update, Delete etc)
  • DB2 Materialized Query Tables (MQTs) to either Netezza CBTs, or Materialized Views
  • DB2 Multi-Dimensional Cluster Indexes (MDC) to either Netezza CBTs or Zone Maps (using Organize On)

In addition, Modak Analytics will help you with:

  • Migration of Load Scripts, ETL Routines (including IBM DataStage, and Informatica)
  • Migration of Business Reporting Tools (e.g. Cognos, Business Objects etc)
  • Migration of other code accessing DB2 (e.g. SAS, Crystal Reports, Custom Java Applications)
  • Potential migration of Indexes to explicit Netezza Zone Maps for optimal performance
  • Migration of Stored Procedures
  • Migration of User Defined Functions (UDF)
  • Scripts for one-time bulk migration of existing Data from DB2 to Netezza
Teradata to Netezza Migration

Netezza transforms the data warehouse and analytics landscape with a platform built to deliver extreme, industry-leading price-performance. With simple deployment, out-of-the-box optimization, no tuning and minimal on-going maintenance, IBM Netezza data warehouse appliance has the industry's fastest time-to-value and lowest total-cost-of-ownership.

Manual migrations are cost intensive and highly error-prone. Modak Analytics 'automated tools' and expertize will speed up the conversion process, minimize downtime and deliver an optimized solution. With a team of highly trained services professionals, we can help you migrate while making sure your business, performance and SLA goals are met.

Modak Analytics's Comprehensive Migration Acceralator tools and program will help with:

  • SQL DDL statements (Create Table, View, Index etc)
    • Datatype Conversion
    • Intelligent Migration of Hash AMP Keys to Netezza SPU Hash Partition
    • Migrate User Accounts, Grants and Privileges
    • Views along with SQL
  • SQL DML statements (Select, Insert, Update, Delete etc)
  • Teradata Join Index, or Aggregate Index to either Netezza CBTs, or Materialized Views
  • Teradata Primary Index to either Netezza CBTs or Zone Maps (using Organize On)

In addition, Modak Analytics will help you with:

  • Migration of BTEQ scripts to either perl/shell scripts, or formal ETL tool
  • Migration of FastLoad, MultiLoad to load scripts or formal ETL tool
  • Migration of Load Scripts, ETL Routines (including IBM DataStage, and Informatica)
  • Migration of Business Reporting Tools (e.g. Cognos, Business Objects etc)
  • Migration of other code accessing Teradata (e.g. SAS, Crystal Reports, Custom Java Applications)
  • Migration of Stored Procedures
  • Migration of User Defined Functions (UDF)
  • Scripts for one-time bulk migration of existing Data from Teradata to Netezza
Teradata to DB2 Migration

DB2 with BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex.

Manual migrations are cost intensive and highly error-prone. Modak Analytics 'automated tools' and expertize will speed up the conversion process, minimize downtime and deliver an optimized solution. With a team of highly trained services professionals, we can help you migrate while making sure your business, performance and SLA goals are met.

Modak Analytics’s Comprehensive Migration Acceralator tools and program will help with:

  • SQL DDL statements (Create Table, View, Index etc)
    • Datatype Conversion
    • Intelligent Migration of Hash AMP Keys to DB2 Hash Partition Keys
    • Migrate User Accounts, Grants, and Privileges
    • Views along with SQL
  • SQL DML statements (Select, Insert, Update, Delete etc)
  • Teradata Join Index, or Aggregate Index to DB2 MQTs

In addition, Modak Analytics will help you with:

  • Migration of BTEQ scripts to either perl/shell scripts, or formal ETL tool
  • Migration of FastLoad, MultiLoad to load scripts or formal ETL tool
  • Migration of Load Scripts, ETL Routines (including IBM DataStage, and Informatica)
  • Migration of Business Reporting Tools (e.g. Cognos, Business Objects etc)
  • Migration of other code accessing Teradata (e.g. SAS, Crystal Reports, Custom Java Applications)
  • Migration of Stored Procedures
  • Migration of User Defined Functions (UDF)
  • Scripts for one-time bulk migration of existing Data from Teradata to DB2