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[这个勾选去掉，用不到]

sql compare options_sql

 

 

 

 

Tools --> Application options

配置保存的sql文件的编码

sql compare options_sql_02