sql compare options

 sql compare project's options

https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options

1. Add object existence checks
2. Use DROP and CREATE instead of ALTER
3. Ignore clollations
4. Ignore database and server name in synonyms
5. Ignore filegroups,partition schemes and partition functions
6. Ignore fill factor and index padding
7. Ignore user properties
8. Ignore white space
9. Ignore WITH element order
10. Ignore DML triggers(if trigger do not need to be deployed)
11. Enable SQL Monitor integration[这个勾选去掉，用不到]

 

 

 

 

Tools --> Application options

配置保存的sql文件的编码,用utf-8 without bom。图中第二个是with bom