How to Compare a Specific Subset of DB Objects

please, is it possible to define and save a (sub)set of objects for comparison? In Databasediff wizard we have an option to define objects, but it’s a bit cumbersome to do the same thing over and over again, so it would be highly useful to save options and selected items for comparison for future use.

Related Posts

Comments 1

We’re actually using this when we do version control. Maintaining a list of all objects related to a project in a cart. Export everything to separate files. Then those files, along with the cart, get committed to the repository. Might I add that the controlling script generated at the end is a pretty great feature too, as you can just “install” everything in one go. Works wonders for our flow.

I see that there is a feature from within the cart to switch the data source for an object to a different connection. Any chance there will be a feature to do the same thing for the “owner” field?
Backstory here is this: developers each have their own DB. When they work on a project, and have to get the latest version of the data model into their DB, they don’t necessarily want to drop the tables, as they will loose all the seed data that is in there. So we just import all the objects to a different schema, and then use the diff tool to get the latest changes into the main schema (as ALTERs). That implies that we end up manually modifying the cart to have it point to a different db connection and owner. And then changing it back.

Being able to change the Data Source field in the cart takes us half way there. A similar feature on the Owner field, would completely solve this for us. I realize this is a little nitpicky, but I’m personally a big fan of streamlining things!