flywaydb and sql server

 

 

https://flywaydb.org/documentation/database/sqlserver

 

How Flyway works

https://flywaydb.org/getstarted/how

 

Commands

Command-line: baseline

 

SQL Server

https://flywaydb.org/documentation/database/sqlserver

Supported Versions

• 2017
• 2016
• 2014
• 2012 Flyway Enterprise
• 2008 R2 Flyway Enterprise
• 2008 Flyway Enterprise

Driver

URL format	jdbc:sqlserver://host:port;databaseName=database
Ships with Flyway Command-line	Yes
Maven Central coordinates	com.microsoft.sqlserver:mssql-jdbc:7.0.0.jre8
Supported versions	4.0 and later
Default Java class	com.microsoft.sqlserver.jdbc.SQLServerDriver

SQL Script Syntax

• Standard SQL syntax with statement delimiter GO
• T-SQL

Compatibility

• DDL exported by SQL Server can be used unchanged in a Flyway migration.
• Any SQL Server sql script executed by Flyway, can be executed by Sqlcmd, SQL Server Management Studio and other SQL Server-compatible tools (after the placeholders have been replaced).

Limitations

• When setting flyway.schemas, the first schema is not set as the default as SQL Server is unable to change the default schema for a session

 

作者:Chuck Lu    GitHub