You could look at SchemaCrawler (http://sualeh.github.io/SchemaCrawler/). I've used it for MySQL databases; it is JDBC-based, so it could certainly be extended to work for Phoenix.

I have in mind to do this myself one day, but not for a while.

James

On 22 August 2015 at 00:50, Saurabh Malviya (samalviy) <samalviy@cisco.com> wrote:

Hi,

 

I am looking for sql diff tool for apache phoenix sql format, Just like http://apgdiff.com/ availalbe for postgresql. 

 

Any pointer ?

 

Another PostgreSQL Diff Tool (also known as apgdiff) is free PostgreSQL diff tool that is useful for comparison/diffing of database schemas. The tool compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one or to see in what exactly both databases differ. It is already being used by many developers all over the world.

 

Thanks,

Saurabh