CODEWITHSUNDEEP
sql-serverfull-text-searchflyway
cin
cin

Reputation: 31

Flyway 5.0.7 non-transactional migrations MS-SQL

I'm using flyway 5.0.7 with MS SQL. I would like to turn on full text search on the server via flyway migrations. Problem is that all migrations are wrapped in transactions and its impossible to create fts catalog and index inside user transactions.

Question is: Is it possible to mark manually migration that it should not be executed in transaction?

I've tried to set mixed option to "true" - no results

I've tried to do some tricks with sp_executesql CREATE FULLTEXT CATALOG .. inside stored procedure and execute this stored procedure in migration. But without any affects

Upvotes: 1

Views: 866

Answers (1)

codemonkey
codemonkey

Reputation: 3830

It's a bug which has been fixed but is not in a release yet. It will be in Flyway 6.0.0 whenever that is released.

In the meantime, you could try the Flyway 6.0.0-beta release

Question is: Is it possible to mark manually migration that it should not be executed in transaction?

I've had a quick look at the code but I can't see a way to override the regex without a code change.

Upvotes: 1

Related Questions