Compare across multiple DBs?

ab_2016 · August 4, 2016 9:39PM

Can SQL Data Compare a single table (or set of tables) across multiple databases? For example, I have one table that I want to compare across 12 databases. I also only want to compare certain columns of the table across the 12 DBs.

Thanks for any help.

Mark J · August 5, 2016 8:09AM

We don't have support for comparing more than two databases in the UI, unfortunately. The easiest way to do this would probably be to use the commandline in a loop to compare against each of the 12 databases: https://documentation.red-gate.com/disp ... mmand+line

To select specific tables and columns for the comparison, you can use 'Mappings': https://documentation.red-gate.com/disp ... ng+objects . These are set up in the UI, but you could save a project file with the relevant mappings set and use that in the commandline.

Does that sound like it would work for you?

ab_2016 · August 5, 2016 8:58AM

Yes, it does sound like it would work. For the command line option, would I need the Pro Edition?

Thanks for your help.

Mark J · August 5, 2016 9:02AM

Yep, the commandline is a feature in Pro edition

Compare across multiple DBs?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk