Comparison tool between 2 vertica databases

Moderator: NorbertKrupa

Post Reply
yahel2410
Newbie
Newbie
Posts: 1
Joined: Tue Jun 11, 2013 8:19 am

Comparison tool between 2 vertica databases

Post by yahel2410 » Wed May 06, 2015 7:58 am

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?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Comparison tool between 2 vertica databases

Post by NorbertKrupa » Wed May 06, 2015 2:39 pm

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.

Post Reply

Return to “Vertica Database Administration”