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

Compare one master DB with 2 or more DB's

Hey all, this is my first post, which is surprising considering I have been using the software for ages now.

Anyway, got a bit of a suggestion for SQL Compare. Would it be possible to compare the schema of one database with two or more databases?

The reason I ask is I have a set up where I have 9 databases that have the exact same schema, just set up for different customers. If I make a change to the schema in test. When making the schema change live I have been using SQL Compare to generate the script, then I copy this script into SQL Multi Script to execute and update.

What you think?

Cheers
Greg
gregsta
0

Comments

2 comments

Sort by
  • dhtucker
    My scenario's nearly the same - only I've got nearly _1300_ databases that need their schema's adjusted when the boss tweaks the tables and fields. I'm really hoping SQL Compare can help (I'm still in the 'evaluation' period).
    dhtucker
    0
  • David Atkinson
    The UI doesn't currently have any one-to-many project option so what I would suggest is that you use the command line to automate this task, or alternatively you could use the Comparison SDK?

    We'll definitely bear your use case in mind and will consider UI support for this.

    Thanks for raising this request. If anyone else is looking for something similar, please let us know.

    Kind regards,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.