Page 1 of 1

Comparison tool between 2 vertica databases

Posted: Wed May 06, 2015 7:58 am
by yahel2410
I need to find the differences between 2 vertica databases on 2 clusters, and generate sql script with the findings. including:
tables, columns, privileges, projections etc.
Is there any tool that can do that?

Re: Comparison tool between 2 vertica databases

Posted: Wed May 06, 2015 2:39 pm
by NorbertKrupa
For schema, table, views and projections, you could just export_catalog and do a diff. For roles, grants, etc., see Doug's script.