Hello.
Liguibase version: 2.0.5
Database: MSSQL 2008
Running via Ant.
I have restored a database from backup as a secondary database, made changes and would like to generate a changelog with the diffDatabaseToChangeLog-target when I get the following exception.
Any ideas how to proceed?
Kind regard,
Andreas
DEBUG 2012-08-31 10:04:liquibase: Connected to dbname@jdbc:jtds:sqlserver://domain:port/dbname
DEBUG 2012-08-31 10:04:liquibase: Reading tables for dbname @ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …
DEBUG 2012-08-31 10:04:liquibase: Reading tables for dbname @ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …
DEBUG 2012-08-31 10:04:liquibase: Reading views for dbname @ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …
DEBUG 2012-08-31 10:04:liquibase: Reading foreign keys for dbname @ jdbc:jtds:sqlserver:// domain:port/dbname (Default Schema: dbo) …
DEBUG 2012-08-31 10:04:liquibase: Reading primary keys for dbname @ jdbc:jtds:sqlserver:// domain:port/dbname (Default Schema: dbo) …
DEBUG 2012-08-31 10:05:liquibase: Reading columns for dbname @ jdbc:jtds:sqlserver://domain:port/dbname (Default Schema: dbo) …
build.xml:86: liquibase.exception.DatabaseException: java.sql.SQLException: Incorrect syntax near ‘2007’.
at liquibase.integration.ant.DiffDatabaseTask.execute(DiffDatabaseTask.java:118)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)