SQL Compare 14.7.8.21163 Not Finding Difference in TEXTIMAGE_ON FileGroup

kaybloodkayblood Posts: 2 Bronze 1
in SQL Compare
We use SQL Compare for object migrations between environments.  Some tables were changed in development to move TEXTIMAGE_ON to a different filegroup, however SQL Compare is not detecting the filegroup difference and shows no differences between the source dev environment and the environment we are migrating to.  If I script the table as create in SSMS in the source & destination, I can see TEXTIMAGE_ON on LOB filegroup in dev & OP filegroup in QA, so I know they are different.  I've tried selecting and unselecting Ignore FileGroups... in project options.  Also, to clarify, and handful of tables that changed were detected fine and another handful it won't detect the changes.
Tagged:
· Share on Twitter

Answers

  • kaybloodkayblood Posts: 2 Bronze 1
    Update - Looks like this is only happening on tables where the only LOB column is datatype geography.  Was able to do a schema compare in SSDT and it detected the filegroup change fine.
    · Share on Twitter
  • Dan_JDan_J Posts: 459 Silver 2
    Hi @kayblood

    My apology for the delay in replying to you on this!

    Would you mind confirming the version of Compare you are using? Also, are you using the GUI or the command line for your comparisons?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.