Topic
2 replies Latest Post - ‏2013-02-23T00:07:22Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic Migrating object names?

‏2013-02-04T22:14:55Z |
Is there a way to preserve the object names (like indices, constraints) during the migration? Is there a setting for this? I'm migrating MySQL 5.5 -> DB2 10.1, using IBM Data Movement Tool 2.00. Currently, the objects do migrate, but their names look auto-generated (starting with UQ_, PK_, etc.).
Updated on 2013-02-23T00:07:22Z at 2013-02-23T00:07:22Z by SystemAdmin
  • nivanov1
    nivanov1
    22 Posts
    ACCEPTED ANSWER

    Re: Migrating object names?

    ‏2013-02-05T15:04:39Z  in response to SystemAdmin
    There is an option in the Options menu: Use Generated Constraint Names. Try unchecking it.
    • SystemAdmin
      SystemAdmin
      708 Posts
      ACCEPTED ANSWER

      Re: Migrating object names?

      ‏2013-02-23T00:07:22Z  in response to nivanov1
      Thanks, I found the setting in the configuration file.
Feed for this topic