Latest| Compatible | ✅ |
|---|---|
| Certified | ✅ |
| Guaranteed | ✅ Flyway Teams |
Support Level determines the degree of support available for this database (learn more).
| 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 |
/* 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');