locked
Compare doesn't update file properties ANSI NULLS RRS feed

  • Question

  • Compare doesn't update file properties ANSI NULLS and Quoted Identifiers.

    File properties ANSI NULLS - project default

    Database settings - ANSI NULLS OFF

    SQL object in DB - ANSI NULLS ON

    Create compare and unchecked - Ignore ansi nulls and click compare.  Compare found that object properties in db and project different. I click update 

    Target database synchronization has started.
    Update plan generated in 00:00:04.1899500 with 0 errors, 0 warnings and 0 messages.
    Analyzing comparison results
    Looking for modified catalog or server options
    Finding dropped objects in the project system
    Finding modified objects in the project system
    Ready to process comparison results
    Target schema updated in 00:00:16.1336468 with 0 errors, 0 warnings and 0 messages.
    Update Target completed in 00:00:20.3299725 with 0 errors, 0 warnings and 0 messages.

    But file properties doesn't change. I click compare and gave the same - object properties in db and project different.

    Why compare update doesn't update file properties?


    Friday, February 8, 2013 6:22 PM

Answers

  • Project defaults are:

    ANSI NULL ON
    QUOTED IDENTIFIER ON

    The SET option at the database level are never used, since every database API which exists override the SET options at the connection and therefore session level which wins. So setting the SET options at the server or database level are true meaningless and changing them does not effect anything. It does not change object which were already created, nor does it change objects which will be created.

    When comparing against a database the object state is retrieved using the OBJECTPROPERTY ExecIsAnsiNullsOn and ExecIsQuotedIdentOn.

    Hope that helps.


    -GertD @ www.sqlproj.com

    • Proposed as answer by Saurabh Sinha DBA Sunday, February 10, 2013 5:45 PM
    • Marked as answer by olegmkr Sunday, February 10, 2013 9:52 PM
    Saturday, February 9, 2013 10:37 PM
    Answerer