Azure Synapse

Azure Synapse

  • Verified Versions: Latest
  • Maintainer: Redgate

Supported Versions and Support Levels

Driver

Item Details
URL format jdbc:sqlserver://host:port;databaseName=database
SSL support Yes - add ;encrypt=true
Ships with Flyway Command-line Yes
Maven Central coordinates com.microsoft.sqlserver:mssql-jdbc
Supported versions 4.0 and later
Default Java class com.microsoft.sqlserver.jdbc.SQLServerDriver

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

Compatibility

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

Didn't find what you were looking for?