CODEWITHSUNDEEP
jdbcflywayjtds
Christopher Green
Christopher Green

Reputation: 13

Flyway with SQL server integrated security

I'm attempting to use jdbc plus jtds to connect to SQL server and run flyway migrations. Its a requirement that the connection use integrated security. Is this supported in flyway? If I specify integratedsecurity=true and don't specify a username and password I am prompted to enter one when I run the command line flyway migrate suggesting that its ignoring my setting to use integrated security.

Upvotes: 1

Views: 1464

Answers (2)

Michael
Michael

Reputation: 172

Now works out of the box -> https://documentation.red-gate.com/flyway/flyway-cli-and-api/supported-databases/sql-server

Windows Authentication

Windows Authentication, also known as Integrated Security, is enabled by amending your JDBC connection string to set integratedSecurity=true.

Syntax: jdbc:sqlserver://:;databaseName=;integratedSecurity=true.

Example: jdbc:sqlserver://server01:1234;databaseName=AdventureWorks;integratedSecurity=true.

Upvotes: 1

Mikiel
Mikiel

Reputation: 448

Flyway doesn't support it out of the box. It's a known limitation.

There is a manual workaround explained on the website.

Upvotes: 1

Related Questions