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

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

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

Comments

3 comments

Sort by
  • 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.
    Tianjiao_Li
    0
  • 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.
    deeps
    0
  • 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.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.