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

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
    78 Posts

    Re: can we ignore index names when compare databases

    ‏2013-03-25T09:13:18Z  
    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

    Re: can we ignore index names when compare databases

    ‏2013-03-25T15:12:06Z  
    • YuanFeng
    • ‏2013-03-25T09:13:18Z
    We have Filter out index function in the Compare with UI,will this help you?
    Which data studio version are you using?
    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
    78 Posts

    Re: can we ignore index names when compare databases

    ‏2013-03-26T07:16:25Z  
    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.
    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.