Options

printing compare configuration

gdmoffittgdmoffitt Posts: 14
edited March 3, 2008 3:44AM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    richardjmrichardjm Posts: 598
    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.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.