# \--diffTypes issue

**URL:** <https://forum.liquibase.org/t/difftypes-issue/2160>\
**Category:** General Discussion\
**Created:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160 "2012-11-22T18:45:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160/1 "2012-11-22T18:45:00Z")

</div>

Try by omitting -diffTypes.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160/2 "2012-11-22T18:45:00Z")

</div>

The doc says it all: [http://www.liquibase.org/manual/diff](http://www.liquibase.org/manual/diff)

> Note: This only works with the “generateChangeLog” command, not the “diff” or “diffChangeLog” commands.&nbsp;

  
Maybe you could implement it and issue a pull request to the github repo?

---

<div class="post-metadata">

**Author:** ![brianboru](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@brianboru](https://forum.liquibase.org/u/brianboru)\
**Post date:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160/3 "2012-11-22T18:45:00Z")

</div>

It sure works but the fact is I need the option…  
  
My database is quite huge and I’d like to omit foreign keys, views and sequences (The diff being too long right now).  
  
Another solution would be to omit some table prefixes (like wiki\_ tables) but I can’t find any way to perform this…

---

<div class="post-metadata">

**Author:** ![brianboru](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@brianboru](https://forum.liquibase.org/u/brianboru)\
**Post date:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160/4 "2012-11-22T18:45:00Z")

</div>

Well… You’re right. I’ve been reading that page like a million times and still I was able to skip these two lines. My bad.  
  
Thanks for the hint, I’ll think about the implementation and request.

---

<div class="post-metadata">

**Author:** ![brianboru](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@brianboru](https://forum.liquibase.org/u/brianboru)\
**Post date:** [November 22, 2012, 6:45pm UTC](https://forum.liquibase.org/t/difftypes-issue/2160/5 "2012-11-22T18:45:00Z")

</div>

Hi all,

I’m new to liquibase and I’m trying to compare my development/production databases (distant) from my local environment using diffChangeLog (from the command line). Which works just fine but for the --difffTypes parameter… Could anybody tell me what’s wrong ?  
  
java -jar liquibase.jar&nbsp;

–driver=com.mysql.jdbc.Driver&nbsp;

–classpath=mysql-connector-java-5.1.13-bin.jar&nbsp;

–changeLogFile=changelog.xml&nbsp;

–url=jdbc:mysql://testing/mydatabase

–username ####

–password=####

diffChangeLog&nbsp;

–diffTypes=tables&nbsp;

–referenceUrl=jdbc:mysql://production/mydatabase

–referenceUsername ####

–referencePassword=####