How can we help you today? How can we help you today?

SQL Compare 14.7.8.21163 Not Finding Difference in TEXTIMAGE_ON FileGroup

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.
kayblood
0

Comments

2 comments

Sort by
  • kayblood
    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.
    kayblood
    0
  • Dan_J
    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?
    Dan_J
    0

Add comment

Please sign in to leave a comment.