# Problem with diffDatabaseToChangeLog from existing database

**URL:** <https://forum.liquibase.org/t/problem-with-diffdatabasetochangelog-from-existing-database/2075>\
**Category:** General Discussion\
**Created:** [August 31, 2012, 5:45pm UTC](https://forum.liquibase.org/t/problem-with-diffdatabasetochangelog-from-existing-database/2075 "2012-08-31T17:45:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![andreas.green](https://avatars.discourse-cdn.com/v4/letter/a/e0b2c6/32.png) [@andreas.green](https://forum.liquibase.org/u/andreas.green)\
**Post date:** [August 31, 2012, 5:45pm UTC](https://forum.liquibase.org/t/problem-with-diffdatabasetochangelog-from-existing-database/2075/1 "2012-08-31T17:45:00Z")

</div>

Hello.&nbsp;

Liguibase version: 2.0.5

Database: MSSQL 2008

Running via Ant.&nbsp;

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.&nbsp;

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&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …

DEBUG 2012-08-31 10:04:liquibase: Reading tables for&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …

DEBUG 2012-08-31 10:04:liquibase: Reading views for&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver://domain:port/dbname(Default Schema: dbo) …

DEBUG 2012-08-31 10:04:liquibase: Reading foreign keys for&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver:// domain:port/dbname&nbsp;(Default Schema: dbo) …

DEBUG 2012-08-31 10:04:liquibase: Reading primary keys for&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver:// domain:port/dbname&nbsp;(Default Schema: dbo) …

DEBUG 2012-08-31 10:05:liquibase: Reading columns for&nbsp; dbname&nbsp;@ jdbc:jtds:sqlserver://domain:port/dbname&nbsp;(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)