How can we help you today? How can we help you today?

Compare across multiple DBs?

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.
ab_2016
0

Comments

3 comments

  • Mark J
    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?
    Mark J
    0
  • ab_2016
    Yes, it does sound like it would work. For the command line option, would I need the Pro Edition?

    Thanks for your help.
    ab_2016
    0
  • Mark J
    Yep, the commandline is a feature in Pro edition
    Mark J
    0

Add comment

Please sign in to leave a comment.