SENTRY QUICKBUILD COMMAND FULL
This comes from the SQL Control product from Redgate and offers quite a full quite of products for the developer and the DBA. Monitor, develop, virtualize, but the main recognition that you’re getting with the periodic table for DevOps tools is for version control and comparisons. There’s just a ton that you can do with Redgate and you can do most of it for Oracle, MSSQL and MySQL, which is way cool. Redgate SQL ControlĮverybody love a great user interface and like most, there’s a pretty big price tag that goes along with the ease of use when adding up all the different products that’s offered. We can be used for versioning, branching and refreshing from a previous snapshot if there was a negative outcome in a development or test scenario, making continuous deployment a reality without requiring “backup scripts” for the data changes. Where Liquibase partners with Delphix is that we can perform continuous delivery via Liquibase and Delphix can then version control the data tier. It may not be version control of your data, but at least you can closely monitor and time out the changes to it. I really like the fact that Liquibase takes compliance into consideration and has the capability to delay SQL transactions from performing without the approval from the appropriate responsible party. You can build just about anything you require and the product has an extensive support community, so if you need to find an example, it’s pretty simple to do so online.
It’s very different from DBMaestro, as it’s the only open source in the database management products and is works with XML, JSON, SQL and other formats. This is the first of two companies we partner with that are in the list.
That it offers all of this through a simple UI is very attractive to the newer generation of developers and DBAs will still want to be part of it.
SENTRY QUICKBUILD COMMAND CODE
The versioning is still as a code change level and not at the data level, but it’s still worthy of discussion. Considering that DevOps is embracing agility at an ever increasing rate, having version control capabilities that will work with both Oracle SQL Developer and Microsoft Visual Studio are highly attractive. DBMaestro allows for this and has some pretty awesome ways of doing it. You want to know that changes to a database occurred in a controlled, documented and organized manner. The first product on the list is something I do like because the natural “control issues” I have as a DBA. The overall goal appears to be version control for your database, which is a pretty cool concept. So let’s first start to discern what the “Database Management” tools are supposed to accomplish and then create one of our own. The rest of the products shown don’t offer any virtualization, (our strongest feature) in their product and we consider Liquidbase and Datical partners in many use cases.Īny tool is better than nothing, even one that helps you choose tools. Focusing on the Database Management toolsets, such as Delphix, I can tell you that only Redgate I view as a competitor and this only happened recently with their introduction of SQL Clone. When comparisons are made, it’s common to have the inability to do apple to apples.
As we all get educated, I’ll focus horizontally in future posts, but today, we’ll take a vertical look at the Database Management tier and where I specialize first. This assists in reach the goals of your solution. The power of this periodic table of DevOps tools, isn’t just that they are broken up by the tool type, but that you’re able to easily filter by open source, freemium, paid or enterprise level tools. This interactive map from XebiaLabs can help offer a little clarity to the solutions, but there’s definitely some holes in multiple places that could be clarified a bit more. It doesn’t hurt to have a map to help guide you. Better communication between teams can offer a better opportunity to deter from holes in development cycle tools, especially when DevOps is the solution you’re striving for. Different combination in the game of tech create a winning roll of the dice and other times create a loss.