How to migrate db2 sql pl scripts to t-sql?

• rrakka-1014540

  SSC Rookie

  Points: 31

  More actions

  January 24, 2012 at 9:16 am

  #263242

  Hi,

  I'm working on a project for migrating db2 database to MS-SQL. I can find guidance on migrating the schema and other db objects using SSIS, i need approach to migrate the embedded db2 sql queries in the applications to t-sql.

  When contacted Microsoft, the SSMA does not support DB2 to MS-SQL at this point and have not indicated any tool being released.

  I'm looking for options to use tools which shall help convert the embedded db2 queries in java and .net applications to t-sql queries and also the stored procedures.

  Any help, shall be appreciated.

  Thanks

  RRAKKA