SQL Compare 126.96.36.19963 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.
0 · Share on Twitter