in liquibase changelog i try to define allow_snapshot_isolation for mssql database:
ALTER DATABASE MY_DATABASE_NAME SET ALLOW_SNAPSHOT_ISOLATION ON;
the question is:
the database name “MY_DATABASE_NAME” is hard coded, is it possible to set MY_DATABASE_NAME as variable? cause i would like let this command work, when database name changed. I use this changelog in a java application.
You can use changelog parameters ( http://www.liquibase.org/manual/changelog_parameters) to have variables in your changelog.
thanks. it works.