Microsoft SQL Server (MSSQL)
Platform Provider:
Other / On-premise
Versions Verified:
2014, 2016, 2017, 2019, 2022
Maintainer:
Liquibase
Detailed verification results:
Foundational Capabilities:
🟢 update family test
🟢 rollback family test
🟢 “SQL” generating variants
🟢 validate
🟢 drop-all
🟢 mark-next-changeset-ran
🟢 changelog-sync
🟢 history
🟢 status
🟢 tag
🟢 unexpected-changesets
🟢 < sql > (or custom equivalent)
🟢 < sqlFile > (or custom equivalent)
🟢 < include >
🟢 < includeAll >
Advanced Capabilities:
⚪ generate-changelog – Pro Enhanced
🟢 SQL
🟢 XML
🟢 JSON
🟢 YAML
⚪ snapshot family – Pro Enhanced
⚪ diff (between databases) – Pro Enhanced
⚪ diff (against snapshot) – Pro Enhanced
⚪ diff-changelog (between databases) – Pro Enhanced
🟢 SQL
🟢 XML
🟢 JSON
🟢 YAML
⚪ diff-changelog (against snapshot) – Pro Enhanced
🟢 SQL
🟢 XML
🟢 JSON
🟢 YAML
🟢 available - paid feature
Table
🟢 createTable
🟢 dropTable
🟢 setTableRemarks
🟢 renameTable
Column
🟢 addColumn
🟢 dropColumn
🟢 renameColumn
🟢 modifyDataType
🟢 setColumnRemarks
🔴 addAutoIncrement
Index
🟢 createIndex
🟢 dropIndex
View
🟢 createView
🟢 dropView
🟢 renameView
Procedure
🟢 createProcedure
🟢 dropProcedure
Sequence
🟢 createSequence
🟢 dropSequence
🟢 renameSequence
🟢 alterSequence
Function
🟢 createFunction
🟢 dropFunction
Package
🟢 createPackage
🟢 createPackageBody
🟢 dropPackage
🟢 dropPackageBody
Synonym
🟢 createSynonym
🟢 dropSynonym
Trigger
🟢 createTrigger
🟢 enableTrigger
🟢 dropTrigger
🟢 disableTrigger
🟢 renameTrigger
Check
🟢 addCheckConstraint
🟢 enableCheckConstraint
🟢 dropCheckConstraint
🟢 disableCheckConstraint
Default value
🟢 addDefaultValue
🟢 dropDefaultValue
Foreign key
🟢 addForeignKeyConstraint
🟢 dropForeignKeyConstraint
🟢 dropAllForeignKeyConstraints\
Not null
🟢 addNotNullConstraint
🟢 dropNotNullConstraint
Primary key
🟢 addPrimaryKey
🟢 dropPrimaryKey
Unique key
🟢 addUniqueConstraint
🟢 dropUniqueConstraint
Data
🟢 addLookupTable
🟢 delete
🟢 insert
🟢 loadData
🟢 loadUpdateData
🟢 mergeColumns
🟢 update
Miscellaneous
🟢 customChange
🟢 empty
🟢 executeCommand
🔴 markUnused
🟢 output
🟢 stop
🟢 tagDatabase
How to Get Started?
Interested in trying the more advanced features of Liquibase Pro? Sign up for a free 30-day trial.