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?
Comparison tool between 2 vertica databases
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Comparison tool between 2 vertica databases
For schema, table, views and projections, you could just export_catalog and do a diff. For roles, grants, etc., see Doug's script.
Checkout vertica.tips for more Vertica resources.