Topic
3 replies Latest Post - ‏2013-03-26T07:16:25Z by YuanFeng
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic can we ignore index names when compare databases

‏2013-03-22T17:18:30Z |
Hi,
We have quite some indexes with the name of SQLyymmddhhmmss.....These are names picked by the system when we created Primary Keys without specifying a name. For the same Primary Key definition, index names are different among various environments since the primary keys were defined at different time..

Is there a way to ignore the name of such indexes when compare databases using Compare With -> Another database Object function.

Thanks
Updated on 2013-03-26T07:16:25Z at 2013-03-26T07:16:25Z by YuanFeng
  • YuanFeng
    YuanFeng
    70 Posts
    ACCEPTED ANSWER

    Re: can we ignore index names when compare databases

    ‏2013-03-25T09:13:18Z  in response to SystemAdmin
    We have Filter out index function in the Compare with UI,will this help you?
    Which data studio version are you using?
    • SystemAdmin
      SystemAdmin
      1632 Posts
      ACCEPTED ANSWER

      Re: can we ignore index names when compare databases

      ‏2013-03-25T15:12:06Z  in response to YuanFeng
      Hi,
      We do not want to filter all indexes since there may be real differences in index definition.
      We would like to have the capability to filter those indexes that have same definition other than a different system generated index name.

      We are using Version 3.2.

      Thank you.
      • YuanFeng
        YuanFeng
        70 Posts
        ACCEPTED ANSWER

        Re: can we ignore index names when compare databases

        ‏2013-03-26T07:16:25Z  in response to SystemAdmin
        Currently we don't have fiter out system index function,but you can in the index->right click->Database Catalo Filter, too filter the index with rule,like not start with...,see the attachement for example.