Comments
9 comments
-
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. -
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?
-
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.
-
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.
-
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
-
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!
-
If you need to compare two SQL database schemas from different servers using DevOps, you can follow these steps:
- Use SQL Server Data Tools (SSDT) – You can use SSDT in Visual Studio to compare database schemas and generate scripts for synchronization.
- SQL Server Schema Compare in Azure DevOps – Integrate SQL Server Schema Compare extension in Azure DevOps to automate schema comparison and deployment.
- Use Redgate SQL Compare – A powerful tool that can compare and synchronize SQL databases across different servers.
- PowerShell with SQLCMD – You can write a PowerShell script to fetch schema details and compare them programmatically.
For those interested in entertainment while working on DevOps and Pikashow for seamless streaming!
-
What we need to do is:
Connect two databases (A and B).
Get their schema definitions (such as tables, fields, indexes, etc.).
Compare the differences (find out the added, modified, and deleted parts).
Automate this process and integrate it into the DevOps pipeline.
If you are interested in some smart tools, you can try:
ired of opening too many tabs to access different writing and research tool websites? We understand your frustration, so Humanize AI provides One-stop Writing Assistant. Save yourself time, energy, and frustration with our range of helpful products.
Deepora AI is an AI model integration platform that allows free access to cutting-edge AI large models such as DeepSeek, ChatGPT,Grok and so on.
-
Hey there! I saw your post about comparing SQL database schema changes between two servers using DevOps, and since you’re new to this, I’m happy to help break it down for you! It’s awesome you’re diving into DevOps—don’t worry if it feels overwhelming at first; it’s all about learning as you go. hill climb racing
Add comment
Please sign in to leave a comment.
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.