Liquibase Community Forum
2010-12-29 22:42:53 UTC
A new topic, 'Syntax to eliminate Sequences from my createChangeLog command line call?', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=869.new#new
The text of the topic is shown below:
I am trying to run an initial createChangeLog to create an initial copy of my database. The database is MsSql, which doesn't use Sequences. Liquibase is erroring out with the following error:
INFO 12/29/10 3:28 PM:liquibase: Reading sequences for XXX @ jdbc:sqlserver://XXX:1433;xopenStates=false;sendTimeAsDatetime=true;trustServrCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;resposeBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCunt=true;encrypt=false;disableStatementPooling=true;databaseName=mwolfson;appliationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
WARNING 12/29/10 3:28 PM:liquibase: Unknown Data Type: -16 (ntext). Assuming i does not take parameters
WARNING 12/29/10 3:28 PM:liquibase: Unknown Data Type: -16 (xml). Assuming it ...
Knowing I don't need to create a ChangeLog that includes Sequences (since they don't exist in my DB), I would like to eliminate this step (thus getting by this problem). I see there is a boolean property named: supportsSequences . I also see that I can issue -D parameters to my command line (ie: -D<property.name>=<property.value> Pass a name/value pair for substitution in the change log(s))
My question: what is the proper syntax for this? I have tried a variety of combinations.
Here is the last one I tried:
liquibase>java -jar C:antlibliquibase.jar --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --classpath=.driversqljdbc4-3.0.1.jar --changeLogFile=com/db.changelog.xml --url="jdbc:sqlserver://XXXX.XXXX;DataBaseName=XXXXX" --username=XXX --password=XXX --Dsupports.sequences=false generateChangeLog
I guess I am not sure I can even do this, hopefully I can, as I am can't even create my initial ChangeLog, so can't proceed to really use Liquibase.
Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.
You can see it at
http://liquibase.org/forum/index.php?topic=869.new#new
The text of the topic is shown below:
I am trying to run an initial createChangeLog to create an initial copy of my database. The database is MsSql, which doesn't use Sequences. Liquibase is erroring out with the following error:
INFO 12/29/10 3:28 PM:liquibase: Reading sequences for XXX @ jdbc:sqlserver://XXX:1433;xopenStates=false;sendTimeAsDatetime=true;trustServrCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;resposeBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCunt=true;encrypt=false;disableStatementPooling=true;databaseName=mwolfson;appliationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
WARNING 12/29/10 3:28 PM:liquibase: Unknown Data Type: -16 (ntext). Assuming i does not take parameters
WARNING 12/29/10 3:28 PM:liquibase: Unknown Data Type: -16 (xml). Assuming it ...
Knowing I don't need to create a ChangeLog that includes Sequences (since they don't exist in my DB), I would like to eliminate this step (thus getting by this problem). I see there is a boolean property named: supportsSequences . I also see that I can issue -D parameters to my command line (ie: -D<property.name>=<property.value> Pass a name/value pair for substitution in the change log(s))
My question: what is the proper syntax for this? I have tried a variety of combinations.
Here is the last one I tried:
liquibase>java -jar C:antlibliquibase.jar --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --classpath=.driversqljdbc4-3.0.1.jar --changeLogFile=com/db.changelog.xml --url="jdbc:sqlserver://XXXX.XXXX;DataBaseName=XXXXX" --username=XXX --password=XXX --Dsupports.sequences=false generateChangeLog
I guess I am not sure I can even do this, hopefully I can, as I am can't even create my initial ChangeLog, so can't proceed to really use Liquibase.
Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.