jvdslikke
jvdslikke
`WITH (DROP_EXISTING = ON)` is unrelated to Enterprise edition IMO, because it's not an Enterprise feature. I think it's always better to do an `ALTER WITH (DROP_EXISTING = ON)` instead...
Hi @maciejw that's true. But in my opinion it should not even be needed to add DROP_EXISTING in the project SQL files, as this does not belong to the model....
This could also be accomplished with the ELEVATE_ONLINE database scoped configuration setting: https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver16#elevate_online---off--when_supported--fail_unsupported-