lbitonti / liquibase-hana

Liquibase Hana extension
Apache License 2.0
11 stars 11 forks source link

diff not displaying differences #14

Open AbdullahChougle opened 6 years ago

AbdullahChougle commented 6 years ago

Hi, While comparing two schemas in my HANA db using the generateChangeLog command line statement, I get the no differences. When I set the log level to debug, I get the following information

liquibase: Did not find catalog 'DEFAULT' to snapshot liquibase: Did not find schema 'SomeSchema' to snapshot similar message is displayed for the other schema

And no differences are displayed Product Name: EQUAL Product Version: EQUAL Missing Catalog(s): NONE Unexpected Catalog(s): NONE Changed Catalog(s): NONE Missing Column(s): NONE Unexpected Column(s): NONE Changed Column(s): NONE Missing Foreign Key(s): NONE Unexpected Foreign Key(s): NONE Changed Foreign Key(s): NONE Missing Index(s): NONE Unexpected Index(s): NONE Changed Index(s): NONE Missing Primary Key(s): NONE Unexpected Primary Key(s): NONE Changed Primary Key(s): NONE Missing Schema(s): NONE Unexpected Schema(s): NONE Changed Schema(s): NONE Missing Sequence(s): NONE Unexpected Sequence(s): NONE Changed Sequence(s): NONE Missing Stored Procedure(s): NONE Unexpected Stored Procedure(s): NONE Changed Stored Procedure(s): NONE Missing Table(s): NONE Unexpected Table(s): NONE Changed Table(s): NONE Missing Unique Constraint(s): NONE Unexpected Unique Constraint(s): NONE Changed Unique Constraint(s): NONE Missing View(s): NONE Unexpected View(s): NONE Changed View(s): NONE Liquibase 'diff' Successful

This is despite both the schemas are starkly different. After analyzing the differences, I want to generate the changelog to be created. As no differences are found, changelog is not generated.

The command used is

liquibase --driver=com.sap.db.jdbc.Driver --classpath=ngdbc.jar --classpath=liquibase-hana.jar --url=jdbc:sap://localhost:30015/ --username=MyUserName --password=MyPassword --logLevel=debug ---defaultSchemaName=FirstSchema diff --referenceUrl=jdbc:sap://localhost:30115/ --referenceUsername=OtherUserName --referencePassword=OtherPassWord --referenceDefaultSchemaName=RefSchemaName

Thanks, Abdullah