SQL Change Automation igone collate
arturcarvalho
Posts: 5 New member
The syncronization script of SQL Change Automation is ignoring COLLATE definition. I made a sql Compare between my database and the shadow, and discover that in shadow the columns have collate to "default" and im my dev database them have collate set to "Latin1_General_CI_AI "
How can i resolve this problem?
How can i resolve this problem?
Tagged:
Answers
You can control this behavior by setting the "SyncOptionIgnoreCollations" to false in your .sqlproj file. Notes on how to make this change and example syntax are in the article, "Configuring comparison & script generation options."
Hope this helps!
Kendra