Schema Sync Tool: Filter On Objects To Compare

[ivan.pagac]

Dear Webyog team,

let me first tell you how great tool you have developed. I tried it some years ago and still actively using it every day, last year I bought license for enterprise version. Part of our project is not covered by any of deployment/migration tool and I need to compare database objects manually, resp. I am using your schema sync tool. It works very nice. But I am missing little feature: filter on objects which are going to be compared. Our typical database has over 500 tables and mostly I am comparing views. That means I have to check “Compare all objects” despite the fact I need to compare only few views. It would be fantastic if you could put there at least filter for object types, for example: [] Tables, [x] Views, [] Functions etc. I would then choose only objects I am interested in, views in this case.

Also I can image go even further, in our project database tables are divided into modules which is presented by appropriate prefix, for example CMS_, CRM_ etc. Usually I am interested in comparing objects for one module, so if I could specify some text filter for objects to be compared – that would be absolutely perfect. I can image similar filter on Object browser panel, let say I want to see only objects starting with CMS_. There is probably hundreds way how to make such filters, for example define multiple rules per filter (“starts with CMS_”, “not ends with _seq”) and have a possibility to switch among different filters.

Bottom line – Any possibilities to filter out objects in Object browser and Schema sync tool would really help me and hopefully many other people using this fantastic tool. On the other hand I understand that this is my personal point of view on topic and you probably have many such requests from different people. Anyway, please let me know if there is any chance to support some filters in future.

Many thanks

Ivan

PS: Is there any way how to write custom plug-ins for SQLyog?

[Author]

Posts