How to work with liquibase, a concrete example

You should never modify a <changeSet> that was already executed. Liquibase calculates checksums for all executed changeSets and stores them in the log. It will then recalculate that checksum, compare it to the stored ones and fail the next time you run it if the checksums differ. What you need to do instead is to … Read more

Add a new table column to specific ordinal position in Microsoft SQL Server

You have to create a temp table that mirrors the original table’s schema but with the column order that you want, then copy the contents of the original to temp. Delete the original and rename the temp. This is what SQL Management Studio does behind the scenes. With a schema sync tool, you can generate … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)