printing compare configuration

gdmoffitt

I have the need to work with developers to review the list of tables and views that are checked or not checked in the setup of a compare. I don't see any obvious way to print out this information, perhaps I'm missing something? We have a compare configuration that includes over 1,000 tables and views and I've had to resort to doing screen prints of the list of tables and views.

Thanks

richardjm

We don't support directly any way to do what you're suggesting. You could fairly easily write a simple SQL Toolkit application which will do as you're suggesting or maybe using the command line will give you what you need.

The only other alternative is to print out the result of a simple comparison where all the tables have a WHERE clause of '1=0' or something so no comparison is performed. At least it would show which tables had unique comparison keys.

Hope that gives you some ideas.