Google Cloud SQL – MSSQL

Verification Category: Advanced

Platform Provider: Google Cloud Platform

Versions Verified: 2019

Maintainer: Liquibase

Resources: Documentation

Detailed verification results:

- Pass - Partial - Fail - N/A

Foundational Capabilities

Change Management Commands

update family test

rollback family test

“SQL” generating variants

validate

drop-all

mark-next-changeset-ran

changelog-sync

Change Tracking Commands

history

status

tag

unexpected-changesets

Native Language ChangeTypes

< sql > (or custom equivalent)

< sqlFile > (or custom equivalent)

< include >

< includeAll >

Advanced Capabilities

Database Inspection Commands

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

Native Executor

available – paid

Supported Standard ChangeTypes

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.

  1. Get started with our Quickstart 
  2. View our Documentation
  3. Take free online training @ Liquibase University
  4. Get your questions answered and participate in the Liquibase Community forums