Ask HN: Compare Schemas of Two Databases

Hello HN community!

I have been searching for a tool that would help me to automate schemas comparison of database instances. My current project is built on top of 15-years old legacy and they got themselves to the situation where instances comparison is required.

I found great stack thread however it's a bit old and tools listed there are also either abandoned or incomplete ( https://stackoverflow.com/questions/4804779/how-to-check-difference-between-two-databases-in-postgresql )

Have anybody had any luck with this kind of problem? If so would you share what you used?

1 comment

[ 0.22 ms ] story [ 17.6 ms ] thread

gquiniou 7y ago ↗

I worked on a project where we would generate XML representations of both databases and then use XSLT style sheets to display the differences.

What I like with this approach is thay you can start with a very simple XML schema and extend it as the need arises. Also you can compare DBs from different vendors as long as you can generate the XML.