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

• 
  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.

  emmar00 February 11, 2025 17:43

  - 0 +
• 
  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?
  
  

  mbarbhaya February 11, 2025 18:48

  - 0 +
• 
  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.

  emmar00 February 11, 2025 19:04

  - 0 +
• 
  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.
  

  JoshH February 12, 2025 15:47

  - 0 +
• 
  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

  mbarbhaya February 12, 2025 15:52

  - 0 +
• 

  Yo team! New to DevOps and want to compare schema between two SQL databases from two different servers? It's as easy as playing Geometry Dash, just need the right timing to pass the level!

  jonesnatelye March 13, 2025 08:01

  - 0 +

Add comment

Please sign in to leave a comment.