Skip to main content

MS-SQLServer®/DB2 MIGRATION ESTIMATE REQUEST

To request a MS-SQLServer to DB2 Migration Estimate from IBM, simply send an e-mail to: db2mig@us.ibm.com and an IBM DB2 Migration Specialist will contact you to initiate the estimation activity and explain the process to you.

Please use the following phrase in the e-mail subject heading:

"MS-SQLServer to DB2 Migration Project Estimate."

For an MS-SQLServer to DB2 Migration Estimate we will need to gather and discuss the following profiles and metrics with you, using a structured document that will be sent to you.

Primary motivators to moving and success measurements:

  • Improved Performance
  • Reduced Ownerships/Operating Costs
  • Access to Skills
  • Industrial DB Reliability
  • Industrial DB Scalability
  • DB Architectural Flexibility
  • Improved Data Integration

Source MS-SQLServer Environment:

  • Source operating system fixpack-level and hardware platform
  • Number of MS-SQLServer instances, release levels and maintenance levels
  • Tables - column structures, complex relationships, sizes, data types used, row sizes, number of rows, average number of rows per table, largest table size
  • Indexes - number of indexes, average number of indexes per table, largest index
  • MS-SQLServer Stored Procedures - numbers, complexity, samples, average lines of code per stored procedure, rollback statements, nesting, etc.
  • DB Triggers - complexity, samples, average lines of code per trigger
  • Columns - data type inventory, are BLOB's used, etc.
  • Replication used
  • Database maintenance schedules and scripts
  • T-SQL used (samples),DBlib, used, CTlib used, JDBC, ODBC
  • Number of MS-SQLServer applications and their processing profile (online, batch, web, read-only, WAP, etc.)
  • Any ISV Applications involved (SAP, Siebel, Peoplesoft, etc.)
  • Any custom code and code profile (language, development and testing)
  • Primary development languages and tools (C, Java, IBM Visual Age, Powerbuilder, Visual Basic, JAVA, C, C++, Visual C++, COBOL, other)
  • Middleware used

Target DB2 Environment:

  • Operating system and hardware platform
  • Development languages and tools
  • Middleware