Schema Comparison returns no results, indicates "Restricted Comparison" RRS feed

  • Question

  • When running the "New Schema Comparison" tool between an SSDT project and a database, the process produces no results, and messages indicating that the comparison was restricted. The specific message is: "Comparison complete. No differences detected. Restricted Comparison. See Error List for details". There are however differences between the project and the db, of that I'm sure. And, there are no errors reported in the Error List.

    Thursday, March 22, 2018 8:16 PM

All replies

  • Hi Mike,

    Which version of Visual Studio you are using?

    Found a similar case here, and the op's resolved by recreating object in MS SQL Server.




    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 23, 2018 2:36 AM