Shadow Baseline - COLLATION issues

HuzzerHuzzer Posts: 1 New member
edited December 22, 2023 10:07AM in Flyway (General Discussion)
Good morning all,
We are trialling the Flyway app and running into a couple of issues when creating the shadow DB.

1. For whatever reason (rightly or wrongly), some of our columns collations don't match the DB collation. Some SPROCs have temp tables which need joining to this column. To work, the collate on the temp table is set to match the column's collation. But the shadow DB baseline seems to ignore column/table collation and set's them all the DB one. Should this process be creating the table/columns with source collation? To make it an exact match after all?

2. When re-running a failed migration (e.g. due to the above), the rerun will always fail as even with a clean, some users remain and it keeps trying to add them again.

Any help, appreciated!
Tagged:

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file