Nathan Voxland

Moorhead, MN

nathan.voxland.net

Age: 37

Primarily Java developer. Started and run the open source Liquibase database change management tool.

5h
comment How to build a WHERE-clause in a LiquiBase changeset
I would suggest just sticking to the <where> block. You can specify You can specify a <whereParam> block with nested <param name="STATE_ID" valueNumeric="3"> tags, but you still need to specify the <where> block with ":STATE_ID=:value" placeholders that are then filled in from value in the <params>. The <param> tags are mainly helpful in handling differences in boolean values across database types.
1d
answered How to build a WHERE-clause in a LiquiBase changeset
2d
revised Database Migration with Liquibase using different DBMS
added changelog parameter option
2d
comment Database Migration with Liquibase using different DBMS
The dbms tag simply "filters" the changeSets to execute based on the target database. It is helpful, but to reduce duplication it's normally best to try to have your changeSets as cross-database as possible. If you simply define your column as type="bigint" or type="varchar(10)" Liquibase will convert it to number(38) on oracle and bigint on mysql, and varchar2(10) on oracle and varchar(10) on mysql. No need to use dbms in this case.
Sep
24
comment Liquibase - checksum differs with different database vendors
OK. I don't remember how that affected checksums in 2.0 but may be the issue. If you use <validCheckSum> like @Andremoniy suggested you can just list the checksums that are known to be valid and it will still fail on all others.
Sep
24
comment Migrate LiquibaseChangeLog entries
It should work to have a separate liqubase run that actually updates the changelog table. Liquibase just reads it at the beginning so anything you to do it after startup should be fine.
Sep
24
comment Migrate LiquibaseChangeLog entries
there is a <validCheckSum> tag you can add to your changeSets when you purposely change the changeSet and want to tag the change as OK. I think that is the same as your canReplaceChecksum
Sep
24
comment Can you reference changelog id in liquibase script?
There are changlog parameters (liquibase.org/documentation/changelog_parameters.html) that can be set changelog-file wide, but they cannot change during the source of execution (i.e. from one changeSet to the next). There are some built-in parameters, mainly around the database such as database.currentDateTimeFunction, database.databaseMajorVersion, database.defaultSchemaName, etc.
Sep
24
comment Liquibase - checksum differs with different database vendors
Thanks, Windows 7 vs. 2008r2 shouldn't affect the checksum. How are you overriding datatypes? Just allowing liquibase to convert them as it normally does, or using changelog parameters?
Sep
23
answered Liquibase tries to create DATABASECHANGELOG although it exists (Vertica)
Sep
23
answered Blobs and Liquibase generateChangeLog
Sep
23
answered Can you reference changelog id in liquibase script?
Sep
23
answered If you have a Liquibase changeset which uses <sqlfile> and you change the file it references
Sep
23
answered Liquibase - common columns?
Sep
23
answered Migrate LiquibaseChangeLog entries
Sep
23
answered dealing with liquibase upgrade that changed MySQL boolean type from tinyint to bit
Sep
23
answered Boolean insertion without quotes - Liquibase over MySQL
Sep
23
answered executing a common sql file using liquibase
Sep
23
answered Liquibase - checksum differs with different database vendors
Sep
23
answered Logging errors with liquibase update command
1 2 3 4 5