Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Unanswered: Migrate from Ingres v.6.4.06

    Hi,

    We're helping a customer to migrate database from Ingres v.6.4.06 to DB2 UDB V8.1. As I have never used Ingres before, I would like to know some more details regarding this product. Please help give me some info :

    1. Does Ingres v.6.4.06 support Triggers, Stored Procedures, User defined data types or User defined functions?

    2. How to export Ingres data into flat text files?

    3. Anyway to export the DDL of the Ingres database schema?

    4. Any websites have the archive manuals of Ingres v.6.4.06?

    5. Anybody have experience to migrate Ingres database, any special things need to aware?

    Regards,

    Patrick

  2. #2
    Join Date
    Aug 2002
    Location
    Brisbane Australia
    Posts
    6
    1. Does Ingres v.6.4.06 support Triggers, Stored Procedures, User defined data types or User defined functions?
    It supports stored procedures and rules (rules may be considered to be triggers)

    2. How to export Ingres data into flat text files?
    use the copy sql command

    3. Anyway to export the DDL of the Ingres database schema?
    use the copydb command and change the copy.in script to remove the copy... from... statements and change the syntax to suit DB2

    4. Any websites have the archive manuals of Ingres v.6.4.06?
    Don't know. I recommend using the customer's ingres manuals that they should have. At least their DBA should have them.

    5. Anybody have experience to migrate Ingres database, any special things need to aware?
    Ingres allows blank dates and strings. This is an issue when moving to oracle, don't know about db2

  3. #3
    Join Date
    Sep 2002
    Posts
    30
    Thanks for your info.

    BTW, are there any tools available on the market which can help to migrate the Ingres ABF applications to Java JDBC application?

Posting Permissions

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