Options

Force Table Rebuild

crancodercrancoder Posts: 28
edited January 4, 2008 9:19AM in SQL Compare Previous Versions
Can someone please provide a complete list of the circumstances under which SQL Compare forces a rebuild of a table?

For example, SQL Compare forces a rebuild if the target table has an identity field, but the source table does not.

Thank you.
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    The list is available on our Knowledge Base already. SQL Compare rebuilds tables if one or more of the following is true:
    - Changing an IDENTITY seed or increment value or dropping the IDENTITY property from a column
    - Adding a column in the middle of a table when the 'force column order' option is enabled
    - When you add/alter/drop PERSISTED computed columns
    - When it is impossible to implicitly cast one data type to another (e.g. DECIMAL to NUMERIC)
    - Changing the filegroup specification for a table
    - Changing partitioned columns
    · Share on Twitter
  • Options
    crancodercrancoder Posts: 28
    Brian - Thanks!
    · Share on Twitter
Sign In or Register to comment.