sql compare project's options
- 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)
Tools --> Application options
配置保存的sql文件的编码