Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Exclamation Unanswered: IMAGE to Any SQL Database

    Greetings buddies from dbForum, this is my first post (pardon my terrible English).

    My problem is: I need to make migration from HP300 IMAGE database to a new relational database that could be SQL Server, MySQL or PostgreSQL (the customer has not yet decided).

    Is that there are ODBC drivers that allow me to convert more easily and thus avoid having to write lots of COBOL scripts.

    Is there a free driver? I got the MiniSoft ODBC32, but only have a demo version. My budget is limited, so I need to get something that is free.

    In advance, thank you very much for their assistance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    COBOL programs are not necessary at all. You can use HP's isql utility to query the data if your want a "zero out of pocket cost" solution, but this still has significant costs in terms of manpower needed for the transfer.

    I can't rememeber an IMAGE/3000 client that didn't have any Windows ODBC drivers. Check with your client, as it would have to be a VERY old installation to not have any ODBC drivers supplied by HP. If the HP-3000 hasn't been under an HP maintenance contract during the last fifteen years, your client could still be running a version that doesn't have any ODBC driver provided by HP.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2009
    Posts
    2
    Thanks Pat, indeed, the installation of my client is very, very old. For about 10 years ago failed to receive support. The client told me also that the database has an estimated time of 16-17 years.

    That means that I do not get any ODBC driver and HP ISQL tool will be useless.

    Now I ask, should I then focus on what I originally thought? (COBOL scripts).

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you have a really, really old version (circa MPE v23.1) you should be able to type IMAGE at the colon prompt. Once there, you can submit SQL queries and get the results as flat text at the console (or send them to files on the HP via MPE FILE statements).

    This is far faster and easier than writing COBOL programs to extract the data, and allows relatively easy portability to most SQL databases.

    I vaguely remember a utility that converted HP IMAGE data that was provided with the Microsoft SQL Server 2000 Resource Kit. I tried to Google it, but didn't have any luck. If you can find that, I think it did much of the transfer work for you.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Sep 2009
    Posts
    1
    Ernesto --> 3rn3st0? ;-)

    I have a similar project coming up. We have a big system that uses IMAGE as the db. We want to get out of MPE (hp-3000) and move to something else...

    If you could share your approach that would be greatly appriciated.

    thanks,
    Tavo

  6. #6
    Join Date
    Sep 2009
    Posts
    39
    Quote Originally Posted by 3rn3st0
    Greetings buddies from dbForum, this is my first post (pardon my terrible English).

    My problem is: I need to make migration from HP300 IMAGE database to a new relational database that could be SQL Server, MySQL or PostgreSQL (the customer has not yet decided).

    Is that there are ODBC drivers that allow me to convert more easily and thus avoid having to write lots of COBOL scripts.

    Is there a free driver? I got the MiniSoft ODBC32, but only have a demo version. My budget is limited, so I need to get something that is free.

    In advance, thank you very much for their assistance.



    from each old databases you can export data to txt files and then load into new databases.

  7. #7
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Just be aware, each database type has a different syntax for importing blob data, so there really is no generic version.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  8. #8
    Join Date
    Apr 2008
    Posts
    2
    Have you looked at IMAGESQL utility (earlier known as ATCUTIL, the ALLBASE/Turbo Connect utility) to make an IMAGE db available over isql?

Posting Permissions

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