Liquibase doesn't work with the change log generated from MSSQL databases for followed changes.
One change is to drop a column which has a foreign key on it. The change log generated by DIFF likes this:
<changeSet author="alan (generated)" id="1216106192953-11">
<dropColumn columnName="DataCreateUser" tableName="EafRole"/>
</changeSet>
...
<changeSet author="alan (generated)" id="1216106192953-31">
<dropForeignKeyConstraint baseTableName="EafRole" constraintName="FK75B85FB1375064CA"/>
</changeSet>
MSSQL rejects dropping this column because the foreign key constraint exists.
And, the another change is addNotNullConstraint. The changeSet generated by DIFF likes this:
<changeSet author="alan (generated)" id="1216106192953-18">
<addNotNullConstraint columnName="Name" defaultNullValue="" tableName="EafUser"/>
</changeSet>
MSSQL rejects the empty defaultNullValue and need a dataColumnType.
Is there anything wrong while I generate the change log?
I love liquibase so much and want to employ it in my team's DB processes. I will really appreciate your help!
Terry
