Azure Synapse

• Verified Versions: Latest
• Maintainer: Redgate

Supported Versions and Support Levels

• For information regarding the supported version and support levels available, please see Supported Databases for Flyway
• For information regarding the Flyway features available, please see Flyway feature summary

Driver

Java Usage

Azure Synapse support is a separate dependency for Flyway and will need to be added to your Java project to access these features. Azure Synapse is found within the flyway-sqlserver plugin module.

Maven

Redgate

<dependency>
    <groupId>com.redgate.flyway</groupId>
    <artifactId>flyway-sqlserver</artifactId>
</dependency>

Open Source

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-sqlserver</artifactId>
</dependency>

Gradle

Redgate

dependencies {
    compile "com.redgate.flyway:flyway-sqlserver"
}

Open Source

dependencies {
    compile "org.flywaydb:flyway-sqlserver"
}

Azure Synapse Syntax

• See SQL Server

Compatibility

• See SQL Server

Example

/* Single line comment */
CREATE TABLE test_user (
  id INT NOT NULL,
  name VARCHAR(25) NOT NULL,  -- this is a valid ' comment
  PRIMARY KEY NONCLUSTERED (name) NOT ENFORCED
);
GO

-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');

Authentication

See SQL Server

Limitations

• See SQL Server
• The JTDS driver does not support Azure Synapse
• Flyway only supports the use of dedicated pools, attempting to use serverless pools will return an 'Unknown SQL Server engine edition: 11' exception.