DB2 - L

  • 1.  Migrate MS SQL Server to Db2 for LUW

    Posted 13 days ago
    Hello everyone.
    A prospective customer has a requirement to migrate an MS SQL Server database to Db2 for LUW. My team has previously done something similar with great success migrating Oracle to Db2 for a large integrated financial services institution. We used what was then called the IBM Data Migration Tool (IDMT) which has been rebuilt as Database Conversion Workbench (DCW). Unfortunately DCW does not currently support MS SQL Server as a source (although I am told that is in plan).

    I am looking for a tool or platform which will help support conversion of the following components from MS SQL Server format or syntax to Db2 as much as possible.
    • data
    • data structures (DDL)
    • SQL
    • Stored Procedures (SPs)
    • application code
    • Concurrency and Consistency control
    • utilities (e.g. backup/recovery, reorgs, etc.)
    • downstream ETL processes
    If you've read this far you probably already know that Db2 natively supports Oracle syntax for SQL and SPs. But that is not the case for MS SQL Server.

    I will be most grateful for any insight you might provide.

    For those who observe - Happy Thanksgiving to you and yours.

    Cheers,
    Frank

    ------------------------------
    FrankFillmoreThe Fillmore Group, Inc.
    ------------------------------


  • 2.  RE: Migrate MS SQL Server to Db2 for LUW

    Posted 13 days ago
    Hi Frank

    I used DCW many years ago in pre-sales in Venezuela, converting T-SQL to db2 with an effectiveness of 99% over 2000 sp. 

    Hope useful to you.
    Nicholas,


    Enviado desde mi iPhone





  • 3.  RE: Migrate MS SQL Server to Db2 for LUW

    Posted 5 days ago
    Nicolas,
    Thank you for your reply. I appreciate the help. Apologies for my delay responding. Last week was a holiday (Thanksgiving) in the US and I am still catching up from taking days off.

    Regards,
    Frank

    ------------------------------
    FrankFillmoreThe Fillmore Group, Inc.
    ------------------------------



  • 4.  RE: Migrate MS SQL Server to Db2 for LUW

    Posted 5 days ago
    Hi Frank, I hope you do well, few customers make the step forward with Db2. Hopefully with COVID-19 they will accelerate.

    Nicholas,





  • 5.  RE: Migrate MS SQL Server to Db2 for LUW

    Posted 4 days ago
    Hi Frank,

    I was wondering, what I was using some time ago for a customer. If the DCW does not help, maybe this one https://github.com/IBM/idmt
    It claims it is follow-up to DMT.

    Cheers

    ------------------------------
    Roland Schock
    ARS Computer und Consulting GmbH
    ------------------------------