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

BUG: Compare sees a suprious duplicate object definition

RikGarnerRikGarner Posts: 4 Bronze 1
edited March 10, 2016 2:04PM in SQL Compare 11
I am attempting a compare between a source scripts folder and a database; the folders contain a Visual Studio Db project (athough the compare dialog detects it as a RedGate compare folder rather than a VS DB project). The comparison fails with the message 'A duplicate definition was found for the user defined type [dbo].[Foo]. Ensure that case sensitivity....'
There is no duplicate definition of the UDT, although there is a table called Foo in a different schema. If I reverse engineer scripts from the database and then use those to do a compare then no duplicate is detected.

Comments

  • Options
    Hello,

    Sorry for the issue you are having with SQL Compare. We've opened a ticket to further investigate this issue. I will respond to you in that ticket after I finish this post, thanks.
    Allen LeVan
    Red Gate Software
    US Product Support
Sign In or Register to comment.