sql compare options
# 数据库 2024-05-05 14:30 0 33 来源: 云博客
- Add object existence checks
- Use DROP and CREATE instead of ALTER
- Ignore clollations
- Ignore database and server name in synonyms
- Ignore filegroups,partition schemes and partition functions
- Ignore fill factor and index padding
- Ignore user properties
- Ignore white space
- Ignore WITH element order
- Ignore DML triggers(if trigger do not need to be deployed)