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

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

    Re: Migrating object names?

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

    Re: Migrating object names?

    ‏2013-02-23T00:07:22Z  
    • nivanov1
    • ‏2013-02-05T15:04:39Z
    There is an option in the Options menu: Use Generated Constraint Names. Try unchecking it.
    Thanks, I found the setting in the configuration file.