liquibase2.0 and mssql 2005/2008: use ALLOW_SNAPSHOT_ISOLATION for different users

General Discussion
1

hello all,

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.

thanks,
wantime

2

You can use changelog parameters ( http://www.liquibase.org/manual/changelog_parameters) to have variables in your changelog.


Nathan

3

thanks. it works.