Rollback fails in MS SQL 2008 using liquibase 3.3.2

Description

Rollback fails in MS SQL 2008 SP 3 using liquibase 3.3.2 and jtds 1.3.1 or Microsoft sqlserver driver 4.1 dirvers.

Steps followed:

Tag

C:\liquibase-3.3.2-bin\liquibase.bat --driver=net.sourceforge.jtds.jdbc.Driver --classpath=C:\jtds-1.3.1-dist\jtds-1.3.1.jar --url="jdbc:jtds:sqlserver://DBServer:1433/DBName" --username=DBUser--password=DBPasswd --changeLogFile=changelog.xml tag tag_123

Result - Tag Sucessful, can see it in databasechangelog

Update

C:\liquibase-3.3.2-bin\liquibase.bat --driver=net.sourceforge.jtds.jdbc.Driver --classpath=C:\jtds-1.3.1-dist\jtds-1.3.1.jar --url="jdbc:jtds:sqlserver://DBServer:1433/DBName" --username=DBUser--password=DBPasswd --changeLogFile=changelog.xml update

Result: Table created, values inserted

rollback

C:\liquibase-3.3.2-bin\liquibase.bat --driver=net.sourceforge.jtds.jdbc.Driver --classpath=C:\jtds-1.3.1-dist\jtds-1.3.1.jar --url="jdbc:jtds:sqlserver://DBServer:1433/DBName" --username=DBUser--password=DBPasswd --changeLogFile=changelog.xml rollback tag_123

Result - Liquibase says "Liquibase Rollback Successful", but the table does exist... it does not drop the table!

The mysql database is working fine, please check - http://stackoverflow.com/questions/28730563/how-does-liquibase-tag-commandline

Project is uploaded to github - https://github.com/amrethc/liquibase_mssql

Environment

Windows Server 2008, Windows 7

Reporter

Amreth Chandrasehar

Components

Fix versions

Affects versions

Priority

Blocker
Configure