What are the challenges you face when working across database platforms? Take the survey
Options

Bug - we exclude comparing Users - compare errors out comparing users

We are comparing 2 versions of our DB. We explicitly uncheck comparing users - we receive the following error:

A duplicate definition was found for the user 'xxxx'. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, please contact Redgate support.

So here we are...
Tagged:

Comments

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    That error is occurring during the registration phase before the filter is effective.

    You should search the scripts folder for any duplicate CREATE statements for that user.

    Sometimes we find that users use the DB folder to store ad-hoc migration scripts, etc. and this can create this issue. No user created files should be stored on the DB folder.

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.