SQL Change Automation igone collate

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?

arturcarvalho May 14, 2019 15:21

Comments

1 comment

Hello,

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

Kendra_Little May 14, 2019 20:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

SQL Change Automation igone collate

Comments

Add comment