Get the most out of Flyway v7 - Sign up for our webinar on the Redgate Hub ▶ Watch now

Azure Synapse

Supported Versions

  • Latest

Driver

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:7.2.0.jre8
Supported versions 4.0 and later
Default Java class com.microsoft.sqlserver.jdbc.SQLServerDriver

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

DB2