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

deepsdeeps Posts: 10 New member
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.
Tagged:

Answers

  • @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.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • deepsdeeps Posts: 10 New member
    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.
  • 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.
    Software Developer
    Redgate Software
Sign In or Register to comment.