Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012

    Unanswered: DB2 for VM to MS SQL conversion

    So, here's the thing, the company I work for currently runs a z/VM 5.2 system using DB2 for VM databases (SQL/DS) and it has just embarked on a project that will move all system activity to a Microsoft AX system with Microsoft SQL.
    I have been asked the question whether or not a tool exists that will perform a conversion from one to the other, and despite trawling search engines, I appear to be unable to find such a tool.
    I've come close, with many references to MVS, OS/390, iSeries etc, but none for VM.
    I'm hoping that with the wealth of experience on this Forum, that someone can either point me in the right direction, or advise me that I am searching in vain. I am aware that the set up we have is somewhat unique.
    Thanks to all for your attention

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    there is a utility that allows you to create the ddl - not for ms/sql but for db2 luw
    most of it can be reused
    you can export data in del format and transfer this file to ms/windows - with translate from ebcdic to ascii
    there is no complete tool for this - better choice would be to move to db2 luw
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jul 2012
    Many thanks for the reply, it is appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts