I have two databases running on separate machines. One is a production server and the other is development.
I've been trying to be careful, but I've gotten out of synch with whether or not I've applied the changes I've made to the development system to the production system. Is there a utility that will compare the tables, functions, trigger, views, etc. between two systems and flag the schema elements that aren't in synch between the two?
If not, and I need to write one, would such a system be of interest to anyone else?
Thanks! Mark
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
