Compare two SQL databases schema changes those are from two different servers, using DevOps

mbarbhayambarbhaya Posts: 5 New member
in General Forum
Team,  
I am new to DevOps, Please help me share the idea and steps to achieve this task .. Compare two SQL databases schema changes those are from two different servers,  using DevOps. 
Tagged:
· Share on Twitter

Answers

  • emmar00emmar00 Posts: 10 New member
    Being that this is in the Redgate forums, I will throw out there SQL Compare. I use in my regular work to compare database object definitions and move things between environments. If you're looking for a more involved DevOps process, perhaps you'd be more interested in Flyway.
    · Share on Twitter
  • mbarbhayambarbhaya Posts: 5 New member
    Thank you emmar,  I am looking for help on something like this article ..
     https://forum.red-gate.com/discussion/86427/data-comparison-in-azure-devops-using-sql-change-automation#latest
    Since I am new to devops,  so I am having difficulty Understanding to integrate SQL Compare with PowerShell in DevOps pipeline then How to use it?

    · Share on Twitter
  • emmar00emmar00 Posts: 10 New member
    The article you linked talks about a different tool, SQL Change Automation. I am not as personally familiar with this tool but it seems like exactly the sort of thing you need. I would recommend you read through the SQL Change Automation documentation. There is a "Getting started" section that could get you off the ground as well as links to training videos and a specific forum where you could ask more specific questions about using the tool.
    · Share on Twitter
  • JoshHJoshH Posts: 65 Bronze 2
    Just to add to what emmar00 said, Flyway is comprehensive DevOps software that covers generation of deployment scripts, integrates into pipelines, and also handles source control. You may want to take a look at that to see if that fits your needs as well.
    · Share on Twitter
  • mbarbhayambarbhaya Posts: 5 New member
    edited February 12, 2025 3:54PM
    Thank you Josh ,  that will be great,  my organization will like to go-ahead with a POC in different features and functionality of Flyway, the one that I saw in Devops marketplace was SQL Change Automation and didnot find Flyway in marketplace.  If you are from Redgate Sales & Support then Please send us an email and we would like to engage more with Redgate products.  Thank you very much 
    · Share on Twitter
Sign In or Register to comment.