loadData with Identity Insert ON

General Discussion
1

What’s the proper XML syntax for this?  Is this even possible?

2

The http://liquibase.jira.com/wiki/display/CONTRIB/MS+SqlServer+Extensions SQLServer extension transparently wraps all loadData and insert calls with a set identity insert on/off


Does that work for you?


Nathan

3

I can not make it work… 


I am using the following command:


java -jar liquibase.jar --changeLogFile=“201301/changelog_test_1.xml” --diffTypes=“data” --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --classpath=lib/liquibase-mssql-1.2.0.jar;sqljdbc4.jar --url=“jdbc:sqlserver://XX\XX;databaseName=X” --username=X --password=X generateChangeLog 


When i check the generated file it does not have anything wraped around the inserts!


What am i doing wrong?


Can anybody help me?


Thanks,

mif

4

My Liquibase version is 2.0.5.

mif

5

It WORKED!!

It must be used as part of the classpath on the migrate command!

Also i used this attachment because i faced the same issue:

https://liquibase.jira.com/browse/CONTRIB-14


THANK YOU Nathan!!