How to avoid table rebuilt when it occurs due to the difference in TEXTIMAGE_ON filegroup property

deeps

When deploying database  with SQL compare and SQL change Automation, the table is rebuilt if there is a difference in TEXTIMAGE_ON filegroup property between source and target database. Tried with the Ignore filegroup SQL compare option. Still rebuilt happens. Please suggest a method to avoid this rebuilt.

Tianjiao_Li

@danyab

I can't reproduce it in SQL Compare 13.6.3. Can you please upgrade and test again?

Should problem persists, please share some screenshots with the problem.

Thanks.

deeps

Thanks for the reply. I am using SQL Compare version 13.3.2. Rebuilt of table does not occur if the difference is only with the TEXTIMAGE_ON filegroup property. If there is any other difference in the table along with the TEXTIMAGE_ON filegroup property rebuilt occurs.

sam.blackburn

SQL Compare rebuilds tables only when it needs to, but there are a lot of reasons why this may happen.  There is usually some explanation for why the table was rebuilt on the Warnings tab.